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

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
  • Comment on Re^3: DBD::SQLite failing to return data?

Replies are listed 'Best First'.
Re^4: DBD::SQLite failing to return data?
by BrowserUk (Patriarch) on Nov 11, 2010 at 01:11 UTC
    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]

        You'd have to drop the semi-colon :)

        But even then, it would die when it reached the end of the data, rather than exiting the loop cleanly and moving on to the next step of the processing.

[reply]

In Section Seekers of Perl Wisdom