Thanks a lot!!
>From: "DJMixes.Com" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: Re: Array Confusion
>Date: Thu, 10 Aug 2000 16:13:12 -0400
>
>You would use loop.
>
> <cfquery datasource="Tester" name="GetNumbers">
> SELECT Quantity, ID FROM TestTable
> </cfquery>
> <cfset QuantityTotal = ArrayNew(1)>
> <cfloop query="GetNumbers" index="x" from="1"
>to="#GetNumbers.RecordCount#">
>
> <cfset QuantityTotal[x] = #Quantity#>
>
> </cfloop>
>
>Derek
>
>"S R" <[EMAIL PROTECTED]> wrote in message
>news:<[EMAIL PROTECTED]>...
> > How do I populate a one dimensional array from a query?? I'm having
>trouble
> > figuring out how I make the 'Array number' dynamic:
> >
> > <cfquery datasource="Tester" name="GetNumbers">
> > SELECT Quantity, ID FROM TestTable
> > </cfquery>
> >
> > <cfoutput query="GetNumbers">
> >
> > <cfset QuantityTotal = ArrayNew(1)>
> >
> > <cfset QuantityTotal[??]] = #Quantity#>
> >
> > </cfoutput>
> >
> >
> > <cfoutput>
> > #QuantityTotal[??]#<br>
> > </cfoutput>
> >
> > Thanks
> >
> > Sal
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >
>--------------------------------------------------------------------------
>----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
