sybperl-l Archive

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