you sure you don't have a <cfabort> or 3 sprinkled in there for
debugging purposes?
On Mon, Mar 3, 2008 at 2:49 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> 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:300346
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
