Also "Date" being a reserved word might be causing you problems
Cheers
Brian
----- Original Message -----
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 8:34 PM
Subject: Re: Why is this query not working in Access??
> Looks like you have single quotes around a date field '#date#' take the
> quotes out ...
>
> You do not put quotes around dates and numbers
>
> Paul Giesenhagen
> QuillDesign
>
> ----- Original Message -----
> From: "Bob Wilson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, August 19, 2002 2:46 PM
> Subject: Why is this query not working in Access??
>
>
> > <html>
> > Hello,<br>
> > <br>
> > Any help is appreciated here. I'm using code I've used before,
> > but<br>
> > Access keeps giving me a syntax error. <br>
> > <br>
> > Here is the query -----------------<br>
> > <cfquery datasource="#application.datasource#"><br>
> > Insert INTO TBLteam ( Title, Team, Author, Date, Body )<br>
> > Values('#Title#', '#Team#', '#Author#', '#Date#', '#Body#')<br>
> > </cfquery><br>
> > <br>
> > <br>
> > And here is the error -----------------------<br>
> > Error Occurred While Processing Request<br>
> > <b><table border=1>
> > <tr><th width=624>Error Diagnostic Information <br>
> > </b>ODBC Error Code = 37000 (Syntax error or access violation) <br>
> > <br>
> > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> > statement. <br>
> > <br>
> > The error occurred while processing an element with a general identifier
> > of (CFQUERY), occupying document position (366:1) to (366:62).<br>
> > </th></tr>
> > </table>
> > <br>
> > I can't seem to get past the Insert request. Oh, the version
> > is<br>
> > CF 4.5.2.<br>
> > <br>
> > Any help is very appreciated.<br>
> > <br>
> > Thanks,<br>
> > <br>
> > Bob<br>
> > <br>
> > </html>
> >
> > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
