Pete Freitag wrote: > > 1) you can turn it into a list with <cfset list = ValueList(query.column)> > If you want an array you can use the ListToArray() function.
I really want an array. :) > > 2) It probably depends on your database version, but you should never rely > on the default, use the AS keyword to name it... SELECT AVG(field_one) AS > alias_name FROM ... MS Access 2000 > > +++++++++++++++++++++++++++++++++++++++++++++ > Pete Freitag ([EMAIL PROTECTED]) > CTO, CFDEV.COM > ColdFusion Developer Resources > http://www.cfdev.com/ > >>Snip!<< ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
