If you reuse the query object, you must query.reset() it each pass in
the loop. If you're using StoredProcs, you must make sure you consume
*all* the result sets.
-----Original Message-----
From: news [mailto:news@stripped] On Behalf Of dwa
Sent: Monday, July 30, 2007 8:42 AM
To: plusplus@stripped
Subject: always the same error-message -sh*t
Hello
in my program - the is always the same loopaction
10 get the current timestamp as ulong
11 insert into timestamptable INSERT INTO TimeStampData(TimeStampValue)
values(ulDateTime)
12 get the auto incremental id mysql_insert_id(...);
13 write Data INSERT INTO ValuesFData (.... + ID + ...)
14 ask for some information SELECT ....
15 read ROW
16 set free -> mysql_free_result(result);
17 sleep
goto start(10)
at(after) the first round - all ok
BUT in the secound round in line 11 the INSERT give the error
--> Commands out of sync; you can't run this command now
I know the error but i cannot find my mistake....
lg
davidwala
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:
http://lists.mysql.com/plusplus?unsub=1
