>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 :)


Is Kdata a date field or a char field?

If its a date field then try
db_qry = db_qry & " where k_date >={" & Date_From & "}"

Jeff