Your code is Perfect (although I like putting a ; after the values line.)
You need to change the field name to something other than DATE (like maybe
"DateEntered"). Then it will work.
Fred
----- Original Message -----
From: "Brian Ingram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 11:43 AM
Subject: Inserting the Date in Access????
> 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.
------------------------------------------------------------------------------
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.
