# 5 needs more input....... ;-) What is the relationship between "count" and "ID" and where does "count" get set?
Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com ----- Original Message ----- From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 3:54 AM 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 > > > ______________________________________________________________________ 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=coldfusiona 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
