Here is the updated code (still does not work):
< %
Date_From = "09/01/1999"
db_qry = "select * from kdata"
db_qry = db_qry & " where k_date >='" & Date_From & "'"
response.write db_qry
set rs = server.createobject("ADODB.Recordset")
rs.Open db_qry , "DSN=foxprocon"
while not rs.EOF
response.write rs("kp_date") & " " & rs("model") & "
"
rs.MoveNext
wend
% >
this outputs the ff. in the browser:
select from kdata where k_date >='09/01/1999'
That's it. It does not enter the while..wend loop and i'm puzzled since the foxpro database is not empty. I checked it and it has a large amount of data.
Again, thanks for the help :)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement