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