Switch the following line in your query profileID = #Session.Profile.profileID#
Also, you may want to consider transferring the session into a local variable to be more flexible with your function call Mike On Jan 26, 2011, at 12:47 PM, Adam Bourg wrote: > > Here's what I'm trying to do. I'm building a module that only our > Professional Staff can access, I am trying to identify where the person > logged in is a pro staff member or a student staffer. When they log into our > CMS, there is a session variable that returns their profile id. it is: > #Session.Profile.profileID# > > We have two tables: > Table 1: pro_profile > Primary key: profileID > This contains all users, their information etc... > > Table 2: mod_userStatus > Primary key: > Sec Key: profileID > This is simply a primary key with a secondary key of profileID. If a person > is on this list they are a prostaffer, if not they are a student. > > I'm trying to query the database and return boolean if the user exists on > mod_userStatus. If yes, they can access the page, if no, redirect. > > Here's the CFC. > > <cffunction name="isStudentEmployee" returntype="boolean" hint="Method to > determine if the person logged in is a student or pro staffer, will corelate > to a control structure if student employee throw up access denied"> > <cfquery datasource="#DSN#" name="isStudentEmployee"> > SELECT > profileID > FROM > mod_userStatus > WHERE > #Session.Profile.profileID# = profileID > </cfquery> > > <cfreturn true> > </cffunction> > > When I run this, it just gives me a blank page, returns nothing and no error. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
