I am fairly new to reactor, so this may be obvious, but I am trying to figure out how to do a GROUP BY on a query set. In the case I am working on, I have an application table, each of which is associated with a benefit in the benefit table. I need to get a list of all of the applications with a given status (appStatus in the application table), grouped by the type of associated benefit in the benefit table.
I know how to get a gateway object for all of the applications with a given status, but how do I group that recordset by the benefit type? Thanks for any pointers. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
