[Mysqlcppapi-main] example programs in mysqlcppapi-1.7.2a

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

I have a problem getting the example programs to run correctly.  In particular,

      ---
      [lance@ll examples]$ ./sinisa_ex
      3.23.24-beta
      Error: You have an error in your SQL syntax near ';/charsets/Index' at line 1 1064
      ---

It correctly shows the output of con.get_client_info(), but then the
query << "show databases" fails.  Does it need a terminating semicolon
or a newline or a flush?

Also, simple1.cc runs fine (after the simple modification of changing
the select_database call to my database and the query to my table):

      ---
      ...
                      con.select_database("mysql_cpp_data");
                      mysqlcppapi::Query query = con.create_Query();
                      query << "select * from stock";
      ...
      [lance@ll examples]$ ./simple2
      Query: select * from media
      Records Found: 767
      ...
      ---

but when the query object is loaded again:

      ---
       ...
                      con.select_database("mysql_cpp_data");
                      mysqlcppapi::Query query = con.create_Query();
                      query << "select * from stock";
      ...    for loop, cout ...
      #ifdef REPEAT_QUERY
                      // n simple1.cc after the first query, for loop, and cout
                      // putting the same string to the same query causes failure
                      query << "select * from stock";
                      /*mysqlcppapi::Result_Store*/ res = query.store();
                      cout << "Query: " << query.preview() << endl;
                      cout << "Records Found: " << res.size() << endl << endl;
      #endif
      ...
      [lance@ll examples]$ ./simple2
      Query: select * from media
      Records Found: 767
      ...
      Error: You have an error in your SQL syntax near '* from medi
      ---

Again I wonder if the query needs semicolon termination, a newline,
or a flush.  If a new query object is created instead of reusing the
query object used previously, the store succeeds.

I'm using Caldera 2.3 and have the following mysql rpms isntalled:

      MySQL-3.22.32-1
      MySQL-client-3.22.32-1
      MySQL-devel-3.22.32-1
      xmysql-1.10-1

And have built, installed, and attempting to run mysqlcppapi-1.7.2a.tar.gz

Help appreciated.  Thanks,  -Lance.


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