in reply to Re^3: 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?.

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.
RIP an inspiration; A true Folk's Guy

Replies are listed 'Best First'.
Re^5: DBD::SQLite failing to return data?
by aquarium (Curate) on Nov 11, 2010 at 03:09 UTC
    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]
        i'm sure i've seen something that gets around this, in an old mysql (4.x) book. sorry.
        the hardest line to type correctly is: stty erase ^H
[reply]

In Section Seekers of Perl Wisdom