Re: selectrow_array() confusion

Works just fine under DBD::Oracle. Are any errors thrown by the DBD driver?

--MidLifeXis

Comment on Re: selectrow_array() confusion

Replies are listed 'Best First'.
Re^2: selectrow_array() confusion by jeffa (Bishop) on Nov 25, 2008 at 20:02 UTC
I was able to get this to work for me as well using MySQL. `use DBI; use Data::Dumper; my $dbh = DBI->connect( 'DBI:mysql:database:host', 'user', 'pass', {RaiseError=>1} ); print Dumper [ $dbh->selectrow_array( 'select max(id),min(id) from movie' ) ];` [download] jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: selectrow_array() confusion
by jeffa (Bishop) on Nov 25, 2008 at 20:02 UTC

I was able to get this to work for me as well using MySQL.

use DBI;
use Data::Dumper;

my $dbh = DBI->connect(
    'DBI:mysql:database:host', 'user', 'pass',
    {RaiseError=>1}
);


print Dumper [
    $dbh->selectrow_array( 'select max(id),min(id) from movie' )
];
[download]

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

[reply]
[d/l]
[select]