> 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?
CF does not have an internal function to convert a query into an array, but someone has probably already done this, so you should search on the Developer's Exchange. > 2) Given the following sql: > > select avg(field_one) > from #application.dns# > > what is the default name for the summary field? If that query is run in CF, the avg() field will not have a name. You need to use the AS command to assign it one "select avg(field_one) as avg_field_one" or something similar. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ______________________________________________________________________ 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
