No, no aborts.. and yeah.. it returns something..
Something's wrong because like I said CF stops processing..
It does this when there are errors in the CFC..
But like I said the getUser works.. the getGroupsForUser doesn't.
The only thing I edited was the emplid for posting purposes.. Other
than that.. right from the page.
I changed the query to
select 1 as group_id, 'Blah' as group_name
from dual
and no luck..
On Mon, Mar 3, 2008 at 4:55 PM, Cutter (CFRelated)
<[EMAIL PROTECTED]> wrote:
> Have you run this query directly at the db, to see if it is in fact
> returning anything? Your function looks correct...
>
> Steve "Cutter" Blades
> Adobe Certified Professional
> Advanced Macromedia ColdFusion MX 7 Developer
> _____________________________
> http://blog.cutterscrossing.com
>
>
>
> Greg Morphis 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:300351
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
