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

Reply via email to