simple date/time parameter problem DW 8.02

[bcunning989]

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

[jimgub]

Hi..

I'm with you.. I am experiencing the exact same issue.. Does anyone have a clue here how to get this resolved?

[lands1ide]

I notice the mismatch errror you are getting. Try to change the data type in the database itself . That should resolve this error.

[bcunning989]

That's the first thing I looked at actually. It's a MS Access Date/Time field. It should just work, but it does not.

[riprod7]

Anyone solved this ????

GOD I HAVE DREAMWEAVER 8.02. ANY CHANCE THEY QWILL RELEASE A DOWNGRADE SOON.

[riprod7]

Anyone solved this ????

GOD I HAVE DREAMWEAVER 8.02. ANY CHANCE THEY WILL RELEASE A DOWNGRADE SOON.