I am trying to cfdump the values on a page that's supposed to display the users
in the system and that file is dspUsres.cfm inside users/view/display but it
says qryUsers is not available. Thanks for any help you provide in advance.
>Eclectic,
>
>You might get a better response posting this to a fusebox forum. I haven't
>used fusebox in years, but I'll take a stab.
>
>You said, " Now I am trying to display the results of qryUsers but qryUsers
>is not available there. I am creating an object but I don't know how to use
>it to access the results of the query. Please guide me."
>
>When you said "there", where do you mean? Also, how are you trying to
>display the 'results' of qryUsers? You said you are creating an object, but
>don't know how to use it. If you can provide more code showing what you are
>doing, that would be helpful.
>
>Again, I'm not sure - I'm just guessing because no one has responded yet,
>and I hate it when that happens to me. ;-) I hope someone on here who is
>more familiar with current fusebox can respond.
>
>Dave
>
>I am new to cfc's and I am having trouble in accessing query results in
>fusebox 5.5.
>I have app.cfc in users/controller and the code in it is following:
>
><cfcomponent output="false">
><cffunction name="dspUsers">
> <cfargument name="myFusebox" />
> <cfargument name="event" />
> <cfset getUsers = CreateObject ("component","users.model.usermanager") />
> <cfset getUsers = myFusebox.do( action="usermanager.qryUsers") />
> <cfset myFusebox.do( action="display.dspUsers", contentvariable="body" )
>/>
></cffunction>
></cfcomponent>
>
>and I have usermanager.cfc in the users/model :
>
><cfcomponent output="false" hint="manage users">
>
><cffunction name="init" returntype="usermanager" access="public"
>output="false">
> <cfargument name="dsn" type="string" required="yes" />
> <cfargument name="dbUser" type="string" required="yes" />
> <cfargument name="dbPass" type="string" required="yes" />
> <cfset variables.dsn = arguments.dsn />
> <cfset variables.dbUser = arguments.dbUser />
> <cfset variables.dbPass = arguments.dbPass />
> <cfreturn this />
></cffunction>
>
><cffunction name="qryUsers" returntype="Query" access="public"
>output="false">
> <cfset var qryUsers = "">
> <cfquery name="qryUsers" datasource="pumas">
> SELECT persons.person_id,
> persons.person_firstname,
> persons.Person_lastname,
> persons.person_membership_type,
> users.user_email,
> users.created_on,
> emails.email_confirmed_on
> FROM persons INNER JOIN
> users ON persons.person_id = users.person_id
>LEFT OUTER JOIN
> emails ON persons.person_id = emails.person_id
> ORDER BY persons.person_firstname, persons.person_lastname
> </cfquery>
> <cfreturn qryUsers>
></cffunction>
>
></cfcomponent>
>
>Now I am trying to display the results of qryUsers but qryUsers is not
>available there. I am creating an object but I don't know how to use it to
>access the results of the query. Please guide me.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310158
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
