Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Re: Determining if a DBI SELECT comes back empty

by tantarbobus (Hermit)
on Dec 05, 2003 at 22:43 UTC ( [id://312680]=note: print w/replies, xml ) Need Help??


in reply to Re: Determining if a DBI SELECT comes back empty
in thread Determining if a DBI SELECT comes back empty

Not all DBDs set the statement handle before a fetch, but MySQL does

But not always. If you create the statement with mysql_use_result rows() will no longer behave that way.

Note that the finish() is required here because you do no fetching. If one of the if's had a fetch, you'd omit the finish().

If one had a fetch() and fetch()ed to the end of the result set. If you fetch 10 rows out of an 11 row result set you will still need to call finish on the sth

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2024-03-28 15:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found