Ramon,

can you output the query after it's been generated so we can see the SQL statement it generates? Often times, it helps to see unclosed single quotes and such. As for OLEDB, sorry, my brain forgot the Foxpro 2.6 part from the top of the e-mail to the time I replied.

Hugo

>i have changed the code as per your advice but it still does not work. I still think the problem is with the sql query:
>
>qry = "select * from kdata where k_date >= '" & datethen & " and"
>qry = qry & " k_date <= '" & datenow & "'"
>
>since when i change the query to:
>
>qry = "select * from kdata"
>
>works well (but not filtered).
>
>I would appreciate it if you could give me a sample code on how to use oledb with regards to this situation.
>
>Thanks.
>
>
>Ramon Carlos
>
>
>>Try this as your while loop:
>>
>>while not rs1.eof
>> response.write rs1("name") & " " & rs1("k_date")
>>wend
>>
>>As well, I would recommend you try to use OLEDB instead of ODBC if possible. We've had problems with ODBC on our IIS server (it would crash for no apparent reason) and we were informed by Microsoft that the ODBC was causing the problems, and that we should move to exclussively ODBC. So much for backward and o-compatible technologies!
>>
>>Hugo