sybperl-l Archive

From: Roleigh Martin <rol at uhc dot com>
Subject: Can someone share a web page/cgi/sybperl script to work with sybase?
Date: Dec 2 1998 9:33PM

Hi,

I've worked with Sybase for 5 years and sybperl 4.X for over 1 
year and know basic HTML but not CGI.  I've recently gotten 
several books, "Offical Guide to Programming with CGI.pm", 
"Building Sybase Web Sites", "Web Programming with Perl 5" and 
"Perl Cookbook."  

I've also asked our Unix (IBM AIX) system administrators to 
install the following upgrades:

   SybPerl (latest version, which is 2.10): 
   http://www.mbay.net/~mpeppler/Sybperl/sybperl-2.10.tar.gz

   Perl (currently Perl version 5.005_02): 
   http://www.perl.com/CPAN/src/stable.tar.gz

   CGI.pm (Perl CGI Subroutine Library, latest version is 2.43): 
   http://stein.cshl.org/WWW/software/CGI/CGI.pm-2.43.tar.gz

   instructions for installing the CGI.pm module: 
   http://stein.cshl.org/WWW/software/CGI/cgi_docs.html#installat
   ion

In addition, I asked for security access (appropriate 
read/write/execute privlege suitable for doing cgi script 
programming) to the cgi-bin, conf, htdocs, httpd, icons, logs, 
support directories beneath the directory where Our_Unix_Box's 
web server points to.

While I am awaiting the above (did I leave anything out?), could 
someone please show me everything that would be required to show 
a web page that shows nothing but the results of doing the 
following task (using something that exists in everybody's Sybase 
database):

   select suid, uid, gid, name from sysusers

   [then from the list that is generated, allowing the user to 
   highlight one line, press double-click with the mouse, and 
   to have the CGI script execute the following (pretend the user 
   highlights the line that shows "dbo")]

   select suid, name, environment=substring(environ,1,25) from 
   sysusers where name = 'dbo'

If I could see how the above is done, I could finish my task very 
fast--the above would be a fantastic example program.

Thanks for helping me.  If anyone can do this, I'll gladly mail them
a free book by Ed and Jennifer Yourdon, Time Bomb 2000 -- just give
me your mailing address.  I have an extra, unused copy of the book
on hand (I'm in the Christmas spirit).

Roleigh Martin

--
Roleigh Martin, Rt. MN012-N188       Opinions are mine not UHC  |
Software Engineer Consultant         AT&T voice:  (612) 992-4592|
UHC, HealthCare System Services      AT&T vmail:  (612) 992-4592|
5901 Lincoln Drive                   FAX:         (612) 992-7021|
Edina MN 55436                       Email:         rol@.uhc.com|
Y2k Page: http://ourworld.compuserve.com/homepages/roleigh_martin
    ( easy to remember alias is: http://webalias.com/roleigh )
(A Web Site that focuses on Y2k threat to core infrastructures.)