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

no execute (after prepare)?

  • Comment on Re: DBD::SQLite failing to return data?

Replies are listed 'Best First'.
Re^2: DBD::SQLite failing to return data?
by aquarium (Curate) on Nov 11, 2010 at 00:12 UTC
    that was my initial thought also. so what happens if you execute?
    the hardest line to type correctly is: stty erase ^H
[reply]
Re^2: DBD::SQLite failing to return data?
by BrowserUk (Patriarch) on Nov 11, 2010 at 00:14 UTC

    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.
[reply]
      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]

In Section Seekers of Perl Wisdom