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: "Avis, Ed" <avised at kbcfp dot com>
Subject: RE: Running multiple SQL statements concatenated together
Date: Oct 14 2003 4:47PM

>>sqsh> select 5 from foo
>>sqsh> select 7
>>sqsh> go

>Err - it would appear that you haven't read the DBD::Sybase docs
>correctly.
>
>Here's how you do it:
>
>$sth = $dbh->prepare($sql_cmd);
>$sth->execute;
>do {
>    while($d = $sth->fetch) {
>        print "@$d\n";
>    }
>} while($sth->{syb_more_results});

Thanks - you're right, I looked only at the DBI documentation.
Guess I should have looked at the Sybase-specific docs before
mailing a Sybase-specific list.

-- 
Ed Avis