take the single quotes out of the field name
>
> ----- Original Message ----- [EMAIL PROTECTED]
> From: Howard Barber <>
> To: <l>
> Sent: Monday, March 19, 2001 10:16 PM
> Subject: "I need a date!"
>
>
> > CF Gurus,
> >
> > I am trying to save a date in CF to an Access database. I either get a
> > syntax or this error:
> > ---
> > ODBC Error Code = S0022 (Column not found)
> >
> >
> > [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
> > contains the following unknown field name: ''datein''. Make sure you
> > have typed the name correctly, and try the operation again.
> >
> >
> > SQL = "INSERT INTO jobs ('datein') VALUES ('03/19/2001')"
> >
> > Data Source = "JOBTICKET"
> > ----
> >
> > The column is there. I have tried specifiying the column in Access as
> > text and date/time. I have tried using the date format functions and
> > with no functions as well. Here is (one version) of my code:
> >
> > <cfset datein = #DateFormat(Now(),"mm/dd/yyyy")#>
> > <cfquery name="addJob" datasource="jobticket" dbtype="ODBC">INSERT INTO
> > jobs ('datein')
> > VALUES ('#datein#')
> > </cfquery>
> >
> > I have dug through my CF books/Forta books and am unable to find an
> > example. Is there a preferred practice of using dates in CF/SQL?
> >
> > Any help is appreciated.
> >
> > -Kevin Barber
> > CF Newbie
> >
> >
>
> -------------------------------------------------------------------------
> > This email server is running an evaluation copy of the MailShield anti-
> > spam software. Please contact your email administrator if you have any
> > questions about this message. MailShield product info:
www.mailshield.com
> >
> > -----------------------------------------------
> > To post, send email to [EMAIL PROTECTED]
> > To subscribe / unsubscribe: http://www.dfwcfug.org
> >
>
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
