RE: [Arsperl-users] ARSystem Menu question...

[Kelly L. <kel...@ra...>]

Hi Jeff,

I would check the permissions on the field that you are searching on.  =
It
sounds like it may only have the default "Submitter" permission group on =
it.
This would only allow the user to see entries that have that user listed =
in
the 'Submitter' field.  Try adding a permission group appropriate for =
that
user; "public" for testing purposes or if you don't have any other main
permission groups.  You should then see all of the entries in that =
search
menu.

Feel free to give me a call if you have any questions.

Kelly Logan
Cybernetic Solutions, Inc.
(313) 586-8334
kel...@cy...

P.S.:  I would have sent this off-list, but I didn't see your contact
information in your message.

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of wheeler, jeff
Sent: 04/14/2005 12:05 AM
To: 'ars...@ar...'
Subject: [Arsperl-users] ARSystem Menu question...


Hi folks -

 I inherited control of an ARS 5.1 system almost 2 years ago and it has =
been
running smoothly.  Until now, the only work that I have been doing on =
the
system was creating report scripts using ARSPerl, and those have worked
without a problem.  Now, however, there has been a renewed interest in
adding functionality to the system for other internal departments. =20


  Since my main role is system administration, I have no training in =
form
development and process flow, but I have a pretty good grasp on how the
basics work.  However, I am having a problem with creating a search-type
menu.  I just wanted to create a menu of names based on already existing
names.  What is happening is that the menu will only contain names that =
were
entered by the user looking at the menu.  I turned on SQL debugging, and =
you
can see it make that call.  However, it doesn't happen when I run as a
member of the Administrators group.  Below is one of the calls:

SELECT T440.C1,C8,C536870927,C7,C8,C536870927,C7,C8=20
FROM T440     =20
WHERE ((T440.C2 =3D 'smsusertest1') OR (T440.C4 =3D 'smsusertest1'))=20
ORDER BY 6 ASC,7 ASC,8 ASC


Here is the same menu call, made from an account the Admin group: SELECT
T440.C1,C8,C536870927,C7,C8,C536870927,C7,C8=20
FROM T440=20
ORDER BY 6 ASC,7 ASC,8 ASC

 =20
If anyone is able to offer suggestions as to what I am doing wrong, =
please
do so offlist - since this isn't ARSPerl related...  Thanks in advance!


jeff





-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users