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
___________________________________________________________________________