|
| |
|
|
intersysop
Posts: 36
Joined: 10/1/2004
Status: offline
 |
Problem with Record Query - 2/8/2009 21:15:11
I am current digging up a old project that i am trying to complete, and i have notice the certain queries no longer work.
one of the query calls to the database record by date for a end of day report.
http://intersysop.com/tvac/Reports/Index_Endofday.asp?Date=2/8/2009
Where the date is call with a <%=date%> Paramerter.
Is this no longer support due to a IIS Update???
Does this type of query need to be modified???
Project is located at http://intersysop.com/tvac
|
|
|
|
William Lee
Posts: 1273
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Problem with Record Query - 2/9/2009 8:40:50
quote:
ORIGINAL: intersysop
http://intersysop.com/tvac/Reports/Index_Endofday.asp?Date=2/8/2009
Where the date is call with a <%=date%> Paramerter.
Date is a reserved word in Access. Avoiding naming your variable or fieldname with Date
_____________________________
William Lee
pǝssǝɟoɹd-ɟ1ǝs ʎɥʇɹoʍʇsnɹʇ ʇsoɯ ɹnoʎ
nɹnb ǝsɐqɐʇɐp & dsɐ ,ʍɹp ,ǝbɐdʇuoɹɟ
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 