Re: Why is this query not working in Access??

charlie griefer Mon, 19 Aug 2002 23:45:44 -0700

i'd rename that 'date' column to something other than date.  It's a reserved 
word in access.


hth,
charlie 

Bob Wilson writes: 

> <html>
> Hello,<br>
> <br>
> Any help is appreciated here.&nbsp; I'm using code I've used before,
> but<br>
> Access keeps giving me a syntax error.&nbsp; <br>
> <br>
> Here is the query -----------------<br>
> &lt;cfquery datasource=&quot;#application.datasource#&quot;&gt;<br>
> Insert INTO TBLteam ( Title, Team, Author, Date, Body )<br>
> Values('#Title#', '#Team#', '#Author#', '#Date#', '#Body#')<br>
> &lt;/cfquery&gt;<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.&nbsp; 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

Re: Why is this query not working in Access??

Reply via email to