actually you can quote dates as long as the format is correct... if it is
wrong you'll get a datatype mismatch error.
You'll want to hard-code values in place of each variable in the VALUES()
clause one at a time until you figure out which one is giving you a problem
and work from there...
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 12:35 PM
To: CF-Talk
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
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
