dbi: selectrow_arrayref

[perlthirst]

As per my understanding we can pass statements (select) to a selectrow_arrayref which will return the first row of data from the statement. But in the manual page there is a statement

"The $statement parameter can be a previously prepared statement handle, in which case the "prepare" is skipped"

Is it giving a meaning that we can pass statement handle to selectrow_arrayref? Is this understanding correct? But if we pass the statement handle to selectrow_arrayref it is throwing error. then what is the meaning of the above quoted string?

Kindly clarify.

[tinita]

But if we pass the statement handle to selectrow_arrayref it is throwing error.

Which error? Please post the code which produces the error and the exact error message.
The following code works for me:

my $dbh = DBI->connect("dbi:...", $user, $pass);
my $sql= "select ... from ...";
my $sth = $dbh->prepare($sql);
my $row = $dbh->selectrow_arrayref($sth);

[Seqi]

you are using:

$dbh->selectrow_arrayref

instead of:

selectrow_arrayref($sth)

right? edit: corrected the calls(?) what I use in a program of mine:

$dbh->selectrow_hashref($sql);

hope this manages to give a hint in the right direction

[bradcathey]

Required reading--you'll want to bookmark this one.