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