From: Warren Young
Date: July 31 2007 3:31am
Subject: Re: always the same error-message -sh*t
List-Archive: http://lists.mysql.com/plusplus/6853
Message-Id: <46AEAD14.3070400@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

dwa wrote:
> 11 insert into timestamptable INSERT INTO TimeStampData(TimeStampValue) 

This is a stored procedure call.  The MySQL C API returns _two_ results 
from a stored procedure call for reasons I don't quite understand.  As 
Jim said, the C API won't let you issue a second query until all the 
results from the first are consumed.  See examples/multiquery.cpp for 
the way to cope with this.