I've been struggling with this all day now... time to ask for help again.
I can set ArrayNames Dynamically like this:
<cfloop index="i" from="1" to="#thePBinsCount.RecordCount#">
<cfset "PBinNameArray#i#" = ArrayNew(1)>
<cfset "PBinQtyArray#i#" = ArrayNew(1)>
</cfloop>
But when I try to fill them them like below I get this error:
The Expression Exception - in line 172 The string "PBinNameArray1[1]" is not
a valid ColdFusion variable name.
<cfloop index="i" from="1" to="#WIP1.RecordCount#">
<cfquery datasource="#request.theDSN#" name="theSumBinCount">
SELECT PBin.Name, Device.Lot_Num, SUM(PBinD.Qty) AS Qty
FROM PBinD
</cfquery>
<cfloop index="j" from="1" to="#theSumBinCount.RecordCount#">
<cfset "PBinNameArray#j#[#i#]" = theSumBinCount.Name[j]>
<cfset "PBinQtyArray#j#[#i#]" = theSumBinCount.Qty[j]>
</cfloop>
</cfloop>
Thank you,
Gonzo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296401
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
