Doh!
New error!
Code:
<cfset Reactor = CreateObject("Component",
"reactor.reactorFactory").init("/reactorxml") />
<cfset UserGateway = reactor.createGateway("#session.the_table#") />
<cfset qUsers = UserGateway.createQuery()>
<cfset qUsers.getOrder().setAsc(session.the_table,"FIRSTNAME")>
<cfreturn qUsers.getAll()/>
Error:
The following information is meant for the website developer for debugging
purposes.
Error Occurred While Processing Request
The method 'getAll' could not be found in component
E:\wwwroot\Reactor\query\query.cfc.
Check to ensure that the method is defined, and that it is spelled correctly.
The error occurred in E:\wwwroot\TruthLogin\methods\db_getAll.cfm: line 12
10 : <cfset qUsers.getOrder().setAsc(session.the_table,"FIRSTNAME")>
11 :
12 : <cfreturn qUsers.getAll()/>
13 :
14 :
Ron Mast
Truth Hardware
Webmaster
507-444-4693
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Works, Jonathan
G.
Sent: Thursday, March 01, 2007 8:05 AM
To: [email protected]
Subject: RE: [Reactor for CF] order by ASC instead of DESC
Your original message had this line:
<cfset UserGateway = reactor.createGateway("#Session.the_table#") />
but i do not see it in the code you included in your last message.
the error is stating that variable does not exist so it looks like you forgot
to include it
:)
Jonathan Works
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Mast
Sent: Thursday, March 01, 2007 8:53 AM
To: [email protected]
Subject: RE: [Reactor for CF] order by ASC instead of DESC
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged,
confidential or otherwise protected from disclosure. If you are not the
intended recipient of this e-mail, please notify the sender immediately by
return e-mail, purge it and do not disseminate or copy it.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
