I want to access SYBASE database using Perl. My client OS is Windows NT Server 4.0
with Sybase installed(e:\sybase,version 11.0.2.1 for NT,almost all compnents
installed),and Perl is ActivePerl-5.6.0.623, also I installed DBI(1.14) and
DBD::Sybase(0.91) using PPM with no further installing ste
try one of the $dbh-select(all|row)_arrayref, this does a prepare & execute
for you. Do a 'perldoc DBI' to read about them.
you have several options:
1 - $dbh->do
2 - $dbh->selectall_arrayref or $dbh->selectall_hashref
3- i don't think execute returns a statement handle.. no I just checked
it doesn't
so $dbh->prepare($sql)->execute; will work but you can't call finish
in the chain.
4 - why don't you read the DBI
Hi all,
For DBI wirh Oracle, instead of typing:
$sth = $dbh->prepare($sql_statement)
$sth->execute();
$sth->finish;
Can I write
$sth = $dbh->prepare($sql_statement)->execute->finish;
Hi again,
Thank you for your last response. Using your input, I was to get a little
further but the make test command is still ending in failure. We've looked
at all the libraries and files to insure that they are present. We've also
removed all of the software and rebuilt Perl, DBI and DBD:In
So does this mean that you would not support extending Date::ISO to
provide a method to output a date in YYY-MM-DD format by default? It
sounds like it does. In that case I would have to think that
creating Date::MySQL would be appropriate.
??
Nick
~~~
Nick Tonkin
On Fri, 2 Nov 2001,
