Kevin: Surely, but from what I have done in the past you have to do a little work (oh, it is not that bad, keep reading). Specifically, loop over the query result set using a for loop in cfscript and then take the records you are looking for and placing them into a structure and array. Another way would be to use a QofQ and use a select statement to create a new query resultset that you can use and then use that resultset within your cfscript block. CFSCRIPT can be addictive, especially when you are doing a lot of comparisons and computations on datasets. I do a lot of management of datasets within cfscript for both what I perceive as "speed" as well as readability of my code. Good luck, -JSLucido
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Sent: Friday, May 04, 2007 11:21 AM To: cflist Subject: [DFW CFUG] cfscript question Ok, I have not taken advantage of cfscript very much but I am trying to. What is the easiest way to group results when using cfscript? I have always just reverted back to <cfoutput query="queryname" group="field"> Kevin Fricke
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
