Edward Diener wrote:
> How can I get my StoreQueryResult to store the row result of my query
> into a vector of my SSQLS structure ? How do I know which result is the
> row result of my query as opposed to the status result which gives only
> a return status from my stored procedure ?
You'd have to modify Query::storein() to teach it about multi-results.
It might be better to fork it, and write storein_multi() instead.
I have never used stored procedures, because I've never run into a
situation where the optimization or security they offer mattered enough
to overcome the associated problems. So, I have essentially no
expertise to draw on, nor interest in seeing the weakness fixed. I'm
willing to discuss patches to do it, but mostly you'd be on your own to
> BTW the example in section 3.12 of the user manual calls a stored
> procedure when the MySQL version is 5.0 or higher but does not set the
> mysqlpp::MultiResultsOption(true) option. Is this an error in the
> example or is there something in the example which would cause it to
> work anyway ?
The latter. It does set MultiStatementsOption(), which is sufficient.