Ron,
<cfset qUsers = UserGateway.createQuery()>
<cfset qUsers.getOrder().setAsc(session.the_table,"FIRSTNAME")>
<cfreturn qUsers.getAll()/>
HTH,
Jon
P.S. Scoping your table into the session scope might be a tad
overkill. Might be better to place it in the variables scope of your
service bean instead - if you need to a scope it at all. - Just a
suggestion.
On Feb 28, 2007, at 10:05 AM, Ron Mast wrote:
Hi All,
The following sorts my query automatically by FIRSTNAME in DESC order.
<!--- create the reactorFactory --->
<cfset Reactor = CreateObject("Component",
"reactor.reactorFactory").init("/reactorxml") />
<!--- create a userGateway --->
<cfset UserGateway = reactor.createGateway("#Session.the_table#") />
<br>
<!--- get all records --->
<cfset qUsers = UserGateway.getAll(sortByFieldList="FIRSTNAME") />
How do I tell Reactor to sort my query in ASC order vs DESC.
Thank you advance,
Ron Mast
Truth Hardware
Webmaster
507-444-4693
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
