[Mysqlcppapi-main] problems with mysqlcppapi running queries

[Lance W. <la...@se...>]

Is anyone out there?  I'm hoping mysqlcppapi is an ongoing an used project!

I'm still having problems - even the example programs don't run correctly.
The first query runs well upon invocation of the store method, but subsequent
queries are still prefixed by the previous query and suffixed by garbage text.

For instance, in simple1.cc (modified only for my database, tables, and fields):

                ...
                con.select_database("tmp");
                mysqlcppapi::Query query = con.create_Query();
                ...
                query << "select * from info ";
                cout << "Query: " << query.preview() << endl;
                mysqlcppapi::Result_Store res = query.store();
                ...
                query << "select * from media " ;
                cout << "Query: " << query.preview() << endl;
                mysqlcppapi::Result_Store res = query.store();
                ...

correctly displays the first preview and query, but then gives the following output:

Query: select * from info select * from media ^H^H| ß^H^H°ß^H^HÀ
Error: You have an error in your SQL syntax near ' select * from media^H^H| ß^H^

Should there be a semicolon ':', use of newline endl or flush?  Help!

Thanks,  -Lance.

-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-
Lance Welsh              la...@se...
Seascape Communications  (650) 327-6890
-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-