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" <webmas...@sstwebworks.com> wrote:
> Nevermind... Damn text wrap on the phone.
> On Jul 9, 2013 8:04 PM, "Scott Stewart" <webmas...@sstwebworks.com> wrote:
>
>> What's the *7 and the * at the end?
>> On Jul 9, 2013 7:59 PM, "Terry Troxel" <terry.tro...@gmail.com> 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:356148
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
