Scott Wilhelm wrote: > 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>
Loose the quotes around the cfqueryparams, add a cfsqltype. Text is not a reserved word in ISO SQL, but might be in your dialect. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
