----- Original Message ----- From: "Scott Wilhelm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 8:09 AM Subject: Query Help Again...
> Can someone tell me what's wrong with this query? I've verified that > everything between this query & the database matches up, I've printed > out the SQL statement, and that was verified through my database that > it's good... > > <cfquery name="InsertLink" datasource="SelfLinks" dbtype="ODBC"> > INSERT INTO Links(Text, URL, SBName, SBEmail, SBSchool, Category) > VALUES( > "<CFQUERYPARAM value="#form.title#">", > "<CFQUERYPARAM value="#form.url#">", > "<CFQUERYPARAM value="#form.name#">", > "<CFQUERYPARAM value="#form.email#">", > "<CFQUERYPARAM value="#form.school#">", > <CFQUERYPARAM value="#cat#"> > ) > </cfquery> > > > I'm getting the following error with it: > > ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO > statement. > > The error occurred while processing an element with a general identifier > of (CFQUERY), occupying document position (25:1) to (25:64). 'TEXT' may not be the best name for a table column...i believe it may be a reserved word in Access. charlie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
