[thelist] ASP & SQL SELECT Query - comparing dates

Ryan Mayberry Ryan at applicor.com
Tue Apr 10 10:19:51 CDT 2001

Hi Elfur !!

-----Original Message-----
From: Elfur Logadottir [mailto:elfur at members.evolt.org]
strSQL2 ="select * from table where date like " & strSQL & " order by
time desc"

Is the date field in your Access database actually called 'date' ?? If so I
have found that this will cause issues with your ASP pages, I'm not 100%
sure why but I think it's because ASP uses the syntax date() to pull the
current date from the server and using this name as a database field causes
some confusion..

Try renaming the data field to 'dtmDate' or 'theDate' or something..

I know that doesn't answer your question exactly, but thought I would give
you the heads up on this as I ran into the issue myself just last night.


More information about the thelist mailing list