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