in reply to Re: DBD::SQLite failing to return data?
in thread DBD::SQLite failing to return data?

Bingo. It's been too long... Many thanks.

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
RIP an inspiration; A true Folk's Guy
  • Comment on Re^2: DBD::SQLite failing to return data?

Replies are listed 'Best First'.
Re^3: DBD::SQLite failing to return data?
by aquarium (Curate) on Nov 11, 2010 at 00:17 UTC
    also are you wanting the data fetch loop to always exit using die?..as there's an endless loop.
    the hardest line to type correctly is: stty erase ^H
[reply]
      also are you wanting the data fetch loop to always exit using die?.

      No. That was just a debugging strategy. In the normal way of things the loop is: 

      while( my $data = $sth->fetchrow_arrayref ) {
    print "$data : @{ $data }";
}

      [download]

      But doesn't give easy opportunity to output any errstr.

      Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
      "Science is about questioning the status quo. Questioning authority".
      In the absence of evidence, opinion is indistinguishable from prejudice.
[reply]
[d/l]
        would this work (untested)? 
        while( my $data = $sth->fetchrow_arrayref || die $sth->errstr; ) {
  print "$data : @{ $data }";
}

        [download]
        the hardest line to type correctly is: stty erase ^H
[reply]
[d/l]

In Section Seekers of Perl Wisdom