Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: FW: dynamic queries using Sybperl CTlib
Date: Oct 26 1999 11:45PM
Abohebeish, Eman wrote:
> > -----Original Message-----
> > From: Abohebeish, Eman
> > Sent: Tuesday, October 26, 1999 4:25 PM
> > To: 'email@example.com'
> > Subject: dynamic queries using Sybperl CTlib
> > Hi,
> > I was wondering if you had an examples of creating dynamic queries using
> > Sybperl CTlib? For example "select $column from sysobjects" where $column
> > is a variable.
You just use the variable... it will just work:
$column = 'name';
$dbh->ct_execute("select $column from sysobjects where type = 'U'");
and then add the usual processing to get the results...
> > Looks like I'm one of the few who is using CTlib module in Sybperl.
> > Thanks for any info. - Eman