Hi, I am trying to add the values from a second query to my first query but for some reason it is setting all rows to the first value of the query. Can someone tell me what I did wrong? TIA.
<CFSET NullArray = ArrayNew(1)> <CFLOOP INDEX="Row" FROM="1" TO="#qryGetOnlineApps.RecordCount#"> <CFSET NullArray[#Row#] = "0"> </CFLOOP> <CFSET Dummy = QueryAddColumn(qryGetOnlineApps,"OfflineApps",NullArray)> <CFLOOP query="qryGetOnlineApps"> <CFSET Dummy = QuerySetCell(qryGetOnlineApps,"OfflineApps",qryGetOfflineApps.TotalOfflineAp p,qryGetOnlineApps.CurrentRow)> </CFLOOP> Tammy ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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