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" <cf-talk@houseoffusion.com> 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'. > > > <cfset mylist="Antiques > Art > Baby > Books > Business & Industrial > Cameras & Photo > Cars, Boats, Vehicles & Parts > Cell Phones & PDAs > Clothing, Shoes & Accessories > Coins & Paper Money > Collectibles > Computers & Networking > Consumer Electronics > Crafts > Dolls & Bears > DVDs & Movies > Entertainment Memorabilia > Gift Certificates > Health & Beauty > Home & Garden > Jewelry & Watches > Music > Musical Instruments > Pottery & Glass > Real Estate > Specialty Services > Sporting Goods > Sports Mem, Cards & Fan Shop > Stamps > Tickets > Toys & Hobbies > Travel > Video Games > Everything Else"> > > <!---Replace all new line characters with pipe symbol for delimeter---> > > <cfset myNewList = #ReReplaceNoCase(myList, "\n" , "|", "ALL")#> > > <!---loop through our new list and insert into database---> > > <cfloop list="#myNewList#" index="listItem"> > <cfquery datasource="nexbid"> > INSERT INTO categories (category) > VALUES (<cfqueryparam cfsqltype="cf_sql_varchar" value="#lTrim(listItem)#"> > </cfquery> > </cfloop> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
