Information générale
Titre:
Accessing Foxpro Data Part 2
Here again is the code I use to access foxpro 2.6 data from visual interdev:
< %
datethen=date()-6
datenow=date()
qry = "select * from kdata where k_date >= '" & datethen & " and"
qry = qry & " k_date <= '" & datenow & "'"
set rs1 = server.createobject("ADODB.Recordset")
open.rs1 qry, "DSN=foxcon"
while not rs1.eof
response.write rs1.name & " " rs1.k_date
wend
% >
I think the mistake is in the field k_date since k_date is a foxpro 2.6 date datatype. I tried using curly braces - it did not work.
Also, I set the foxcon DSN at the system DSN in ODBC Data Sources in Control Panel. I don't think the problem is here since the query works well when I leave out the k_date condition.
Can somebody help me fix my code?
Ramon Carlos
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