I've been having problems inserting the CurrentDate in Access as well. I've tried
setting the data type up as a text and as a date/time, but neither work.
What is the best way to do it?
When i try to insert the date i get this error:
===========================
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
=========================
I've checked my syntax about a million times (it's right), but it still wont work.
If this helps this is the code i'm trying to do it with:
<CFSET CurrDate = "#DateFormat(now(), "MM/DD/YYYY")#">
<CFQUERY DATASOURCE="whatever">
INSERT INTO Review(Date)
VALUES ('#CurrDate#')
</CFQUERY>
thanks in advance for your help,
brian
-----------------------------------------------
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
