I solved it with the first couple of posts help. 

New code: 

    <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="ArchimedesCMS" name="isStudentEmployee">
                SELECT
                profileID
            FROM
                mod_userStatus
                WHERE
                profileID = #Session.Profile.profileID#
        </cfquery>

      <cfif isStudentEmployee.recordcount eq 0>     
          <cfreturn true>   
      <cfelse>   
          <cfreturn false>   
      </cfif> 
      
        
    </cffunction>

That returns true or false. Then I invoke the method, return a variable and do 
a CF control structure and works no problem now. 

Thanks for the help. 

Adam 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:341399
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to