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.
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 ... +++++++++++++++++++++++++++++++++++++++++++++ Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -----Original Message----- From: John White [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 1:59 PM To: CF-Talk Subject: Query into Array, averages in SQL statement All, Two quick questions. 1) Is there an array or structure returned with a query that can be addressed in subsquent processing? Or must you use some type of cfloop or cfscripting to move the results of a query into an array? 2) Given the following sql: select avg(field_one) from #application.dns# what is the default name for the summary field? --JW ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
