[Mysqlcppapi-main] using query object twice

[Norbert K. <nor...@sc...>]

hello everybody,

can anybody please give me a hint what's going wrong.

the code should run on an smp machine with debian-woody,
gcc-3.2.3,
mysqlcppapi-1.9.2.

the program is multithreaded.

<codesnippet>

        mysqlcppapi::Query query = connection_->create_Query();
 
        query << "select * from browser";
        mysqlcppapi::Result_Store res = query.store();
 
        mysqlcppapi::Result_Store::iterator it = res.begin();
        while( it != res.end() )
        {
		//do something 
        }
         
        query << "select * from os" ;
        res = query.store();

        it = res.begin();
        while( it != res.end() )
        {
		//do something
        }

</codesnippet>

please take a look at mysql.log:


                    601 Init DB     WebstatMeta
                    601 Query       select * from browser
030403 10:57:06     601 Query       select * from browserselect * from
os
                    503 Quit       

please reply to my email address since i am not ( yet ) subscriber of
the list. 

thx
norbert
-- 
First newbie rule: IGNORE the flamers...
Second newbie rule: DON'T give up...      Jerry McBride in Alt.Linux
THIRD newbie rule: see first rule...
alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/perl/fom