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: Beth Breidenbach <Beth dot Breidenbach at BankAmerica dot com>
Subject: problems with ct_execute
Date: Oct 8 1998 6:07PM

I'm unable to retrieve results from ct_executein my cgi, but _am_
able to successfully use ct_sql to get the same results.  Both
versions (ct_execute and ct_sql) work when called from the command
line.

The code is listed below.  We're using perl 5.004, Apache 1.3.?,
mod_perl 1.15, on Solaris 2.6, with Sybase 11.5.

Anyone have a suggestion as to what I'm missing???????

---------- code below  ---------------------------

use CGI::Switch;
use Sybase::CTlib;
...print some html stuff....
$db=Sybase::CTlib->ct_connect('userid','passwd','server');
$db->ct_execute("select uid, name from sysuers");
while ( $db->ct_results($result) == CS_SUCCEED) {
    next unless $db->ct_fetchable($result);
    while ( ($uid, $name) = $db->ct_fetch ) {
        print "$uid - $name\n";
    }
}
...print more html stuff...

If I substitute $db->ct_sql(select statement) for the ct_execute
statement and set @rows equal to the result, it works fine.  And,
the above works correctly if run command-line at the terminal.

Help?????????

Beth Breidenbach