> I really want an array. :) <cfset queryArray = ListToArray(ValueList(query.columnName))>
>> 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 You must have misread that, It's NOT a good idea to be version specific in your code if you can avoid it. So you can name it what ever you want using the AS keyword in your query... SELECT AVG(field_one) AS avgField FROM table Now the result of AVG(field_one) is stored in a column called avgField +++++++++++++++++++++++++++++++++++++++++++++ Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
