To me, that seems to hacky. If roles for user A was simply, 

<cfquery name="getroles" ...>
        select rolename from you get the idea
</cfquery>

I'd simply turn this into a UDF called getRoles(name). Use it when you
logon and use it when you need the list.

========================================================================
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email    : [EMAIL PROTECTED]
Blog     : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -----Original Message-----
> From: Candace Cottrell [mailto:[EMAIL PROTECTED] 
> Sent: Monday, June 30, 2003 9:15 AM
> To: CF-Talk
> Subject: RE: CFLOGIN Quickie - Ray
> 
> 
> Hmmm... that seems like something one would need to know... 
>  
> Maybe you could do...
>  
> <CFLOGINUSER
>        NAME="#GetUser.UserID#,#GetUser.UserFirstName#,
> #GetUser.RoleName#"
>          PASSWORD="#FORM.Password#"
>         ROLES="#TRIM(GetUser.RoleName)#">
>  
> And then parse it out of the name part.
>  
> Of course, this would assume that each user only has one role.
>  
>  
> Candace K. Cottrell, Web Developer 
> The Children's Medical Center 
> One Children's Plaza 
> Dayton, OH 45404 
> 937-641-4293 
> http://www.childrensdayton.org
>  
>  
> [EMAIL PROTECTED]
> 
> >>> [EMAIL PROTECTED] 6/30/2003 10:55:56 AM >>>
> Even though you said ignore, I'm going to respond anyway. ;) 
> There is no way currently to get a list of the roles a user 
> belongs to, so you must write your own system. This could 
> easily be done w/ a UDF. The actual code of the UDF will 
> depend on your security implementation.
> 
> ==============================================================
> ==========
> ===
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> (www.mindseye.com)
> Member of Team Macromedia
> (http://www.macromedia.com/go/teammacromedia)
> 
> Email    : [EMAIL PROTECTED] 
> Blog     : www.camdenfamily.com/morpheus/blog 
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> > -----Original Message-----
> > From: Candace Cottrell [mailto:[EMAIL PROTECTED]
> > Sent: Monday, June 30, 2003 8:51 AM
> > To: CF-Talk
> > Subject: Re: CFLOGIN Quickie - SOLVED-Ignore
> > 
> > 
> > IGNORE this... all I needed to do was a trim here:
> >  
> > 
> >       <CFLOGINUSER
> >         NAME="#GetUser.UserID#,#GetUser.UserFirstName#"
> >         PASSWORD="#FORM.Password#"
> >         ROLES="#TRIM(GetUser.RoleName)#">        
> >  
> > It's Monday... please forgive me.
> >  
> > Candace K. Cottrell, Web Developer
> > The Children's Medical Center 
> > One Children's Plaza 
> > Dayton, OH 45404 
> > 937-641-4293 
> > http://www.childrensdayton.org 
> >  
> >  
> > [EMAIL PROTECTED]
> > 
> > 
> 
> 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to