List:MySQL++« Previous MessageNext Message »
From:Jim Wallace Date:July 30 2007 4:30pm
Subject:RE: always the same error-message -sh*t
View as plain text  
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

Thread
always the same error-message -sh*tdwa30 Jul
  • RE: always the same error-message -sh*tJim Wallace30 Jul
  • Re: always the same error-message -sh*tWarren Young31 Jul