> 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?
When your run a CFQUERY that returns records, you end up with a Query object. You can transpose the values within that object into an array or a structure, but you don't usually have to, as you can do most of the things you need to do with the Query object itself. You can think of a Query object as a structure of arrays, in which the arrays represent the columns of the query, although it isn't exactly that. It might be more useful for you to describe the kind of operation you want to perform; that operation may be possible without any transposition. > 2) Given the following sql: > > select avg(field_one) > from #application.dns# > > what is the default name for the summary field? This will vary based on your database platform, I think. I'd recommend that you use an alias, rather than leaving it up to the computer: SELECT AVG(field_one) AS myfieldavg ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ 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
