Aaron,
Right on! That works perfectly - thanks for your assistance.
Michael
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Aaron Keller
Sent: Monday, July 23, 2007 1:45 PM
To: [email protected]
Subject: Re: List of users in a group
**
Use a SQL menu:
select full_name from user_x where group_list like '%$groupID$%'
of course, you'll have to have another SQL menu which lists the group
names, and a link that looks up the groupID for the specified group:
select group_name, group_id from group_x
The above syntax assumes Oracle; you might have to tweek it a bit for
other DBs
-Aaron
* Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD
Sent: Monday, July 23, 2007 3:13 PM
To: [email protected]
Subject: List of users in a group
**
I'm trying to create a menu that lists people who are in a certain
group, but Public does not have access to the User form and I don't wish
to make it that way - the People form doesn't contain group information.
Ideas?
Thanks,
Michael
The information contained in this email may be privileged, confidential
or otherwise protected from disclosure. All persons are advised that
they may face penalties under state and federal law for sharing this
information with unauthorized individuals. If you received this email
in error, please reply to the sender that you have received this
information in error. Also, please delete this email after replying to
the sender. __20060125_______________________This posting was submitted
with HTML in it___
SunCom is the wireless company that's committed to doing things
differently.
Things we want you to know.
This e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication may contain material protected by the
attorney-client privilege. If you are not the intended recipient or the
person responsible for delivering the e-mail to the intended recipient,
be advised that you have received this e-mail in error and that any use,
dissemination, forwarding, printing or copying of this e-mail is
strictly prohibited.
__20060125_______________________This posting was submitted with HTML in
it___
The information contained in this email may be privileged, confidential or
otherwise protected from disclosure. All persons are advised that they may
face penalties under state and federal law for sharing this information with
unauthorized individuals. If you received this email in error, please reply to
the sender that you have received this information in error. Also, please
delete this email after replying to the sender.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
