Question
simple date/time parameter problem DW 8.02
I used to be able to do this, but now I haven't a clue. I am
trying to get a simple search on a date field, using a form field
on a previous page to pass the date to the results page. The SQL is
SELECT *
FROM gongwernews
WHERE DateEntered = MMColParam
The parameter section in the Advanced Recordset box shows
Name: MMColParam
Type: Date
Value: Request.Form("DateEntered")
Default Value: 01/01/2006
When I click the test button I get the error
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression
When I got that in MX04 I put the hashes around the #MMColParam# and all was well. Now when I do that I get the additional information in the error message
Syntax error in date in query expression 'DateEntered = #"'01/01/2006'"#'.
Note the three quote marks. Where did they come from? How do I do this in 8.02? I've searched the forum and technotes but I don't seem to find what I need.
Thanks in Advance,
Bill Cunningham
SELECT *
FROM gongwernews
WHERE DateEntered = MMColParam
The parameter section in the Advanced Recordset box shows
Name: MMColParam
Type: Date
Value: Request.Form("DateEntered")
Default Value: 01/01/2006
When I click the test button I get the error
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression
When I got that in MX04 I put the hashes around the #MMColParam# and all was well. Now when I do that I get the additional information in the error message
Syntax error in date in query expression 'DateEntered = #"'01/01/2006'"#'.
Note the three quote marks. Where did they come from? How do I do this in 8.02? I've searched the forum and technotes but I don't seem to find what I need.
Thanks in Advance,
Bill Cunningham
AdChoices