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'. <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:260450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
