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

Re: Multiple data sets in MySQL stored procedures

by smiffy (Pilgrim)
on Jan 04, 2009 at 21:55 UTC ( #734060=note: print w/ replies, xml ) Need Help??


in reply to Multiple data sets in MySQL stored procedures

Just providing a cross-reference here. I asked for clarification on this issue, but ended up getting the answers through experimentation.

If one creates a stored procedure that always returns a known number of result sets (probably good practice to do this anyway), the only difference to the "traditional" usage of DBI is that you need to call $sth->more_results() before retrieving each new set (otherwise you don't get the new set.)

So, this means that $sth->more_results() doesn't just mean "are there more results?" but is also the command to retrieve the next result set.

Please see the node I have referenced above for examples.


Comment on Re: Multiple data sets in MySQL stored procedures

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (9)
As of 2015-07-07 10:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls