If I dump the application scope, I can see the userGateway and function..
usergateway
component qRunner.cfcs.users.UserGateway
GETGROUPSFORUSER
function getGroupsForUser
Arguments:
Name Required Type Default
emplid Required Any [empty string]
Return Type: query
Roles:
Access: public
Output: false
I'm baffled!
On Mon, Mar 3, 2008 at 4:14 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> So I'm trying to learn the whole OO stuff behind CF..
> I've got a user gateway, dao, bean created.. but something is up with
> one of the functions...
>
> I'm creating the gateway in the application.cfc
> <cfset application.userGateway = createObject("component",
> "cfc.users.UserGateway").init( DSN = application.DSN ) />
>
> my Gateway works here..
> <cfset foo = application.userGateway.getUser(emplid = '0012345') />
>
> I can see in the debug where it's called and ran...
> qUser (Datasource=j00mamma, Time=539ms, Records=1) in
>
> C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\qRunner\cfcs\users\UserGateway.cfc
> @ 16:08:22.022
>
> SELECT
> emplid,isadmin
> FROM
> users_tbl
> WHERE
> emplid = ?
> AND
> isactive = 1
>
>
> Query Parameter Value(s) -
> Parameter #1(cf_sql_varchar) = 0012345
>
> Okay, so that's all cool.. so why is THIS not working????
>
> <cfset qGroupsX = application.userGateway.getGroupsForUser(emplid =
> '0012345')>
>
> CF just stops processing.. anything that should have followed the call
> is not there.. so I look in my GateWay and here's my query...
>
> <cffunction name="getGroupsForUser" access="public" output="false"
> returnType="query" hint="returns a recordset of groups per user">
> <cfargument name="emplid" default="" required="true">
>
> <cfset var qGroups = "" />
>
> <cfquery name="qGroups" datasource="#variables.DSN#">
> select gt.group_id, gt.group_name
> from groups_tbl gt
> left join group_user gu
> on gt.group_id = gu.group_id
> and gu.emplid = <cfqueryparam
> cfsqltype="cf_sql_varchar"
> value="#arguments.emplid#">
>
>
> </cfquery>
>
> <cfreturn qGroups />
>
>
> </cffunction>
>
>
> Nothing fancy... am I'm missing something here? Why isnt this working?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300345
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
