Nevermind... Damn text wrap on the phone. On Jul 9, 2013 8:04 PM, "Scott Stewart" <[email protected]> wrote:
> What's the *7 and the * at the end? > On Jul 9, 2013 7:59 PM, "Terry Troxel" <[email protected]> wrote: > >> >> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC >> Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT >> INTO statement. The error occurred in >> *C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm: >> line 7* >> >> 5 : <cfquery name="addcat" datasource="#dsn#" maxrows=1> >> 6 : insert into cats(atitle,desc)*7 : >> values('#atitle#','#desc#')* >> 8 : </cfquery> >> 9 : <cfelseif x is "update"> >> >> ------------------------------ >> SQLSTATE 42000 SQL insert into cats(atitle,desc) values('f','g') >> VENDORERRORCODE -3502 DATASOURCE libertree >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
