use the value of "thisItem". phillip
-----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 6:55 AM To: CF-Talk Subject: mass database update I am doing a mass update of a table. The query looks like this: <cfloop index="thisItem" from=1 to=#listlen(ID)#> <cfquery name="query_InsertItems" datasource="firehook1"> Update Inv1 Set Count = #Count# Where ID = #ListGetAt(ID, thisItem)# </cfquery> </cfloop> What I am getting is this: Update Inv1 Set Count = 9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9 Where ID = 2077 I know that I have to associate a quantity (count) with an ID, but I am not sure how to go about it. I tried nesting loops and creating arrays and such with no luck. Any assitance would be greatly appreciated. Thanks, _________________________________________ Bruce Sorge ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
