Hi Jon,
Thanks for the response btw...:)
Now the implementation issue.
Here's what my code looks like:
<cfset Reactor = CreateObject("Component",
"reactor.reactorFactory").init("/reactorxml") />
<cfset qUsers = UserGateway.createQuery()>
<cfset qUsers.getOrder().setAsc(session.the_table,"FIRSTNAME")>
<cfreturn qUsers.getAll()/>
I'm getting the following error with the above code:
The following information is meant for the website developer for debugging
purposes.
Error Occurred While Processing Request
Variable USERGATEWAY is undefined.
The error occurred in E:\wwwroot\TruthLogin\methods\db_getAll.cfm: line 6
4 : <cfset Reactor = CreateObject("Component",
"reactor.reactorFactory").init("/reactorxml") />
5 :
6 : <cfset qUsers = UserGateway.createQuery()>
7 :
8 : <cfset qUsers.getOrder().setAsc(session.the_table,"FIRSTNAME")>
What am I doing wrong?
Thanks,
Ron Mast
Truth Hardware
Webmaster
507-444-4693
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Clausen
Sent: Wednesday, February 28, 2007 6:20 PM
To: [email protected]
Subject: Re: [Reactor for CF] order by ASC instead of DESC
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
