Jochem van Dieten writes: > 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
the error message, if i recall correctly, stated MS Access as the database. I suggested 'text' might be a reserved word based on information found here: http://www.additionalinfo.com/ai/tools.asp?tid=28 :) 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
