At 05:54 AM 01/15/2002 -0600, you wrote: > 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 don't see where count is defined, but if I understand the problem, but it sounds like the problem is with the Count variable. If you are trying to set every value to 9, you are complicating it greatly (but I suspect you are not trying to do that) -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- DotComIt: Database Driven Web Data My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide February 2002 -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists