oops. except for your cfset statement and that's just improper use of the
""s. change the two outside quotes to single quotes ' '
Fred
----- Original Message -----
From: "Fred T. Sanders" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 1:26 PM
Subject: Re: Inserting the Date in Access????
> 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.
------------------------------------------------------------------------------
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.
