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). Thanks in advance! Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
