Here is what I ended up doing:
<cffunction name="UserRights" output="true" returntype="any">
<cfargument name="stgAppID" required="true" type="string">
<cfargument name="stgUserID" required="true" type="string">
<cfargument name="stgModuleName" required="true" type="string">
<cfstoredproc datasource="SecuritySQLServer"
procedure="USP_UserRights" >
<cfprocparam type="in" value="#stgUserID#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#stgAppID#"
cfsqltype="cf_sql_varchar">
<cfprocparam type="in" value="#stgModuleName#"
cfsqltype="cf_sql_varchar">
<cfprocresult name="qGetRights" resultset="1">
</cfstoredproc>
<cfset stcAccess = StructNew()>
<cfset stcAccess.WithAccess = Iif(qGetRights.WithAccess EQ 1,
TRUE, FALSE)>
<cfset stcAccess.WithReadOnly = Iif(qGetRights.Mod_ReadOnly EQ
1, TRUE, FALSE)>
<cfset stcAccess.WithAdd = Iif(qGetRights.Mod_Add EQ 1, TRUE,
FALSE)>
<cfset stcAccess.WithModify = Iif(qGetRights.Mod_Modify EQ 1,
TRUE, FALSE)>
<cfset stcAccess.WithDelete = Iif(qGetRights.Mod_Delete EQ 1,
TRUE, FALSE)>
<cfset stcAccess.IsAdmin = Iif(qGetRights.Administrator EQ 1,
TRUE, FALSE)>
<cfreturn stcAccess>
</cffunction>
---
Calling:
<cfset stcWithAccess = UserRights("CSI_NEW", "#CGI.LOGON_USER#", "CSI
Main")>
I need to clean it up a little, like for when no records are returned.
But this seems to work. Tom and Dave, thanks a bunch.
Russel Madere
Webmaster
504.832.9835
SunShine Pages by EATEL
www.sunshinepages.com
-----Original Message-----
From: Russel Madere [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 10:18 AM
To: CF-Talk
Subject: RE: ColdFusion UDFs and passing variables by reference
Never mind. I figured that little bit out. I can just pass it out of
the UDF.
Russel Madere
Webmaster
504.832.9835
SunShine Pages by EATEL
www.sunshinepages.com
-----Original Message-----
From: Russel Madere [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 10:03 AM
To: CF-Talk
Subject: RE: ColdFusion UDFs and passing variables by reference
All I have to say is Doh! I'm not thinking well this morning.
Do I have to instantiate the structure outside of the UDF or can I just
create it inside and pass it out.
Russel Madere
Webmaster
504.832.9835
SunShine Pages by EATEL
www.sunshinepages.com
-----Original Message-----
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 9:57 AM
To: CF-Talk
Subject: Re: ColdFusion UDFs and passing variables by reference
On Friday 09 June 2006 15:12, Russel Madere wrote:
> Can I use the CALLER scope to return multiple variables from the UDF?
Yes, but why not just return a structure or object ?
--
Tom Chiverton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243038
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
