Awesome! :) On 1/26/2011 1:31 PM, Adam Bourg wrote: > 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:341400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm