FrontPage/ Access SQL Data Type Mismatch

M

M Fichter

Hi.

I am using a FrontPage .asp file with a connection to an
MS Access 2000 database to perform queries.

The SQL is simple and works fine for string type data.
However, when I try to build the query results based on an
Access DATE field, I am getting a Data Type Mismatch
error. Apparently, FrontPage is not sending the proper
syntax through ODBC to Access. I do not see a "Date" type
formfield property option in FrontPage. I have tried a
number of formatting adjustments without success.

Can someone tell me how to overcome this problem?

Thanks,
MF
 
Top