So the query comes back with no results if it's a student? Why not do
something like?
<cfif isStudentEmployee.recordcount eq 0>
<cfreturn true>
<cfelse>
<cfreturn false>
</cfif>
On 1/26/2011 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:341388
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
