Article 12680 of comp.lang.perl:
Xref: feenix.metronet.com comp.lang.perl:12680
Newsgroups: comp.lang.perl
Path: feenix.metronet.com!news.utdallas.edu!chpc.utexas.edu!cs.utexas.edu!swrinde!sgiblab!munnari.oz.au!newsroom.utas.edu.au!ml.csiro.au!solaris!jstander
From: jstander@ml.csiro.au (Jeff Stander)
Subject: Re: OraPerl & SybPerl SQL-generator
Message-ID: <1994Apr13.235040.13379@ml.csiro.au>
Sender: news@ml.csiro.au
Reply-To: jstander@ml.csiro.au
Organization: CSIRO Marine Laboratories
References: <2nre3i$rib@aurns1.aur.alcatel.com>
Date: Wed, 13 Apr 1994 23:50:40 GMT
Lines: 41

In article rib@aurns1.aur.alcatel.com, beardall@aur.alcatel.com (Russ Beardall) writes:
>I have a friend (don't we all?) that is looking for a sub or library of subs for
>Ora/SybPerl that would auto-gen SQL statements of different kinds.
>
>The idea would be a sub such as: 
>
>&autoGenSql("selectAll","tablename",@somearray) etc.
>
>which would automatically generate the necessary actions to select all values from
>tablename and stuff it into @somearray which would be the expected parameters of 
>the selectAll parm type.
>
>Thanx
>-Russ

I have some routines that I've written that might
be of some use.  You can find them as part of the
compressed archives for xsql in the following location:

	host:	ftp.ml.csiro.au
	IP:	192.67.12.100
	dir:	/pub/jstander/xsql

Let me know if you find any of them useful and please
let me know of any problems.  At the moment they work only
for OPS$ type logins, but that's easily fixed.  Look at sqlx.pl
and misc.pl when you extract the archive.

Jeff


---
___________________________________________________________________________

Jeff.Stander@ml.csiro.au        _--_|\        Database Analyst
CSIRO Division Of Fisheries    /      \       Pelagic Fisheries Resources
GPO Box 1538, Hobart           \_.--._/       Tasmania 7001, Australia
Aus Tel: 002-325-332                 v        Intl Tel: +61-02-325-332
Aus Fax: 002-325-000                          Intl Fax: +61-02-325-000
___________________________________________________________________________