[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.
Later
Ryan
More information about the thelist
mailing list