Ah well - Thanks for the inputs guys ;o)
The eventual result was trying to get the sum off all the values in a given column of a query. Discovered the very easy way of doing this was via: ArraySum(query[column]); Which works a treat (still not sure WHY it works however - maybe queries are really just 2d arrays... which wouldn't be THAT surprising). Thanks anyway. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Steve Onnis <[EMAIL PROTECTED]>: > nope > > you cant put anything inside a ValueList function apart from > QueryName.Column > > nothing will work > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Geoff > Bowers > Sent: Wednesday, November 19, 2003 10:49 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Dynamically giving a column to ValueList? > > > Mark M wrote: > > However, is there a way i can set the column name dynamically? I've tried > every which way I > > can think of - but maybe something like? > > > > column = "cityName"; > > list = ValueList(query[column]); > > What about: > list = ValueList(evaluate("query.#column#")); > > -- geoff > http://www.daemon.com.au/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
