RE: always the same error-message -sh*t

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@sea.gmane.org] On Behalf Of dwa Sent: Monday, July 30, 2007 8:42 AM
To: plusplus@lists.mysql.com
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....

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

lg
davidwala

-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:
http://lists.mysql.com/plusplus?unsub=jwallace@kaneva.com


-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=lists@pantek.com