On Tue, 2007-06-12 at 17:16 -0500, Jim Wallace wrote:
> I call them all them time. There are a couple gotcha about using stored
> procs. First you need to setup to get multiple reset sets, which is a
> MySQL requirement:
Thank you! I took the '::Option' out of this line
m_conn->set_option(Connection::Option::opt_reconnect, true);
and followed your advice about pulling off the empty result set by
adding
while (query.more_results()) {
// throw away empty results that are side effect of multi-query
res = query.store_next();
}
Without that I had been seeing
Query error: Commands out of sync; you can't run this command now
Also looked at examples/multiquery.cpp as Warren Young pointed out.
Everything working now. Thanks for your help and to to the mysqlpp team
for a very nice piece of OSS software!
Will
--
William F Dowling
william.dowling@stripped
www.scientific.thomson.com
