PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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:   'perl5-porters@perl.org'
> > 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.

Not really

> >
> > Thanks for any info.  - Eman

Michael