Hello Guyz!!!

I`ve got the following code...
<%
Dim oRSbn
Set oRSbn=server.createobject("ADODB.recordset")
hi = "1/1/1980"
hi1 = "1/1/2010"
sqltext = "Select * from fotofiles WHERE dato BETWEEN '"& hi &"' AND '"& hi1 &"';"
oRSbn.open sqltext, conn
if (oRSbn.EOF) then
response.write oRSbn("dato")
end if
response.write hi
response.write hi1
%>
I get the following error
----------------
Error Type:
ADODB.Recordset (0x800A0BB9)
Unknown runtime error
/1.asp, line 7
-----------------
What`s wrong? :(

Please let me know which database you are using.
Also, detail on the field types used in the database.

I`m using MS Access

I`ve set "dato" field in type date.

Then use "#" instead of "'" to compare the date value.

ie.
sqltext = "Select * from fotofiles WHERE dato BETWEEN $"& hi &"# AND #"& hi1 &"#;"

Let me know if it works out.:)

Thank you for your reply... But no... It`s not working!

You have a "$" which I tried also with "#" and again it doesn`t work. :(
Any other ideas?

Did you get the same error?

I just got mis-spelled
it is not "$", it is always "#" surrounded for date in MS Access

Can you post your latest SQL query..

sqltext = "Select * from fotofiles WHERE dato BETWEEN #"& hi &"# AND #"& hi1 &"#;"

:( I understood that you misspelled that.. but even with the # is not working for me.

;;;is not working for me

Your query looks good to me post your exact error and run time behaviours for a useful solution. I would:
1..Check your variables hi and hi1 are valid date data types
2..Hardcode dates in place of your variables to eliminate this as a problem
3..Comment out the execute() then write your query to screen, copy n pasted it directly into Acesss and run it?




Wind is your friend
Matt

Thank you people...! I had an error with my connection to the db! :(

Sorry for my late reply...