Thanks Andrew. Yes, except that I plan to use the one dimension array to populate a new column in an existing query with this statement a bit later in the code.
<cfset nColumnNumber = QueryAddColumn(WIP1, "thePBinName#i#", "PBinNameArray#i#")> On Jan 10, 2008 11:03 PM, Andrew Scott <[EMAIL PROTECTED]> wrote: > Would it not be better to make the arrays 2 dimensional? > > > On 1/11/08, Gonzo Rock <[EMAIL PROTECTED]> wrote: > > 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:296406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
