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:356145
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
