sybperl-l Archive

From: "Dennis R dot Sherman" <sherman at trln dot lib dot unc dot edu>
Subject: tool search: one row in column-name: value format?
Date: Nov 7 1995 3:24PM

In the interest of not reinventing someone elses wheel, does anyone have
a script to share that will

* take as input username, password, database, tablename, where-clause
* produce as output a listing of all rows in the named table that meet
  the criteria of the where-clause, in a form similar to
  
========== (row separator) ======
column-name1: value1
column-name2: value2
column-name3: value3
etc.

I'm attempting to automate some testing, and something like this will
make it a lot easier.  Scripts via email or pointers to WWW or FTP
locations appreciated.

Oh, I'm using Sybase 10.0.2, perl 4.036, sybperl 1.12.

Thanks.
--
  Dennis R. Sherman  	         Triangle Research Libraries Network
  dennis_sherman@unc.edu       Univ. of North Carolina - Chapel Hill
               http://www.unc.edu/~sherman/