Thanks. I hate it when the little stuff haunts you -)
Doug ----- Original Message ----- From: "Bobby Hartsfield" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> 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'. > > > <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:260456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4