RE: Sql error during insert
-Original Message- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: 11/14/06 7:17 PM Subject: Sql error during insert I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sql error during insert
Thanks. I hate it when the little stuff haunts you -) Doug - Original Message - From: "Bobby Hartsfield" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, November 14, 2006 8:21 PM Subject: RE: Sql error during insert > You are missing a ) after the queryparam > > > ..:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > > -Original Message- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 14, 2006 10:15 PM > To: CF-Talk > Subject: Sql error during insert > > I do not recall seeing this before. Could someone tell me what I am doing > wrong? I get the following error while executing this query. > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax > near '@P1'. > > > > > > > > > > > > >INSERT INTO categories (category) >VALUES ( value="#lTrim(listItem)#"> > > > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sql error during insert
Never mind...I missed a closing ) on my query. Geez looked at it forever. D.B - Original Message - From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, November 14, 2006 8:15 PM Subject: Sql error during insert > I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. > > > > > > > > > > > > >INSERT INTO categories (category) >VALUES ( > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sql error during insert
You also need to specify the delimiter in your loop as a | ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 10:22 PM To: CF-Talk Subject: Re: Sql error during insert If this is a true "copy and paste", you're missing your ending ')' in the VALUES statement. On 11/14/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > I do not recall seeing this before. Could someone tell me what I am doing > wrong? I get the following error while executing this query. > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect > syntax near '@P1'. > > > > > > > > > > > > >INSERT INTO categories (category) >VALUES ( value="#lTrim(listItem)#"> > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sql error during insert
You are missing a ) after the queryparam ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 10:15 PM To: CF-Talk Subject: Sql error during insert I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. INSERT INTO categories (category) VALUES ( ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sql error during insert
If this is a true "copy and paste", you're missing your ending ')' in the VALUES statement. On 11/14/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > I do not recall seeing this before. Could someone tell me what I am doing > wrong? I get the following error while executing this query. > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect > syntax near '@P1'. > > > > > > > > > > > > >INSERT INTO categories (category) >VALUES ( value="#lTrim(listItem)#"> > > > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Sql error during insert
I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. INSERT INTO categories (category) VALUES ( ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4