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:300347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
