Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: Re: SQLite Documentation

by Ovid (Cardinal)
on Jun 04, 2003 at 21:46 UTC ( [id://263159]=note: print w/replies, xml ) Need Help??

in reply to Re: SQLite Documentation
in thread SQLite Documentation

Wow, do I feel stupid. I completely missed that :) The following replicates his problem (along with the error message):

my $sql = "SELECT * FROM foo"; my $sth = $dbh->prepare($sql) || die "Couldn't prepare $sql: $DBI::err +str"; while ( my @row = $sth->fetchrow_array ) { print "@row\n"; }

This appears to be a bug in the error reporting.


New address of my CGI Course.
Silence is Evil (feel free to copy and distribute widely - note copyright text)

Replies are listed 'Best First'.
Re: Re: Re: SQLite Documentation
by cidaris (Friar) on Jun 05, 2003 at 14:41 UTC
    Well, don't feel stupid, Ovid.
    After further examination and the hints of a few whispered messages (silent11) I realized that the "while" construct doesn't actually execute the prepared statement, only receives the output and continues to as long as it is produced.

    Adding an $sth->execute() directly before the loop solved the problem.

    I can't find an example in my code, but I feel fairly certain that I always just went straight to the "while" construct without an "execute()" with DBD::MySQL, but then again, I could be wrong.

    I usually am. ;)


Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://263159]
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2024-04-21 21:00 GMT
Find Nodes?
    Voting Booth?

    No recent polls found