No problem, glad I could help On Jul 9, 2013 8:35 PM, "Terry Troxel" <[email protected]> wrote:
> > That was it changed to desc1. > > Thank you very much. > > Terry > > > On Tue, Jul 9, 2013 at 5:08 PM, Scott Stewart <[email protected] > >wrote: > > > > > A couple of things though.... Desc is a SQL reserved word. You may need > to > > express the field name as [desc]. Second please wrap those variables in > > cfqueryparam tags. > > On Jul 9, 2013 8:05 PM, "Scott Stewart" <[email protected]> > wrote: > > > > > 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:356153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
