Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Re: Re: SQLite Documentation

by cidaris (Friar)
on Jun 05, 2003 at 14:41 UTC ( [id://263349]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: SQLite Documentation
in thread SQLite Documentation

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. ;)

--cidaris

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2024-04-24 09:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found