Re: More DBI Problems!!!

[repson]

in reply to More DBI Problems!!!

It would help if you told us which line 50 was in the future.

However, I think the problem is in
$dbh->selectrow_array($query)

The method selectrow_array is for performing a full prepare, execute and returning the array. The parameter is an sql string, not a query object.

What you probably meant was:
$query->fetchrow_array

Which returns a single row of the prepared and executed query it is call on.

[chipmunk]

I think repson must be right that you meant to use $query->fetchrow_array instead of $dbh->selectrow_array($query).

However, the $dbh->select... methods can take an already prepared statement handle as the first argument. This allows you to prepare the statement once ahead of time, and then execute it with select... many times. For example:

my $sth = $dbh->prepare(<<EndOfSQL);
  SELECT name
  FROM   item
  WHERE  id = ?
EndOfSQL

while (<>) {
  chomp;
  if (($name) = $dbh->selectrow_array($sth, {}, $_)) {
    print "$_ => $name\n";
  } else {
    print "$_ not found\n";
  }
}