Single quotes around the text values. Jerry Johnson
>>> [EMAIL PROTECTED] 01/14/03 10:09AM >>> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
