[Arsperl-users] ARSystem Menu question...

[wheeler, j. <whe...@em...>]

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.  


  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 
FROM T440      
WHERE ((T440.C2 = 'smsusertest1') OR (T440.C4 = 'smsusertest1')) 
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 
FROM T440 
ORDER BY 6 ASC,7 ASC,8 ASC

  
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