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