Hi,

I use to have in 2.1.1 the following statement:

try { mysqlpp::Query query = _con.query();

query << "UPDATE clienttransfer SET seq=1;" <<endl; cout << query.preview() << endl; query.execute(); } catch{ cerr << "Error setCompletedEntries:" << er.what() << endl; } return SUCCESS; }

I now get with 2.2.0 version an error:

Error setCompletedEntries: You have an error in your SQL syntax that corresponds to your MYSQL server version for the right syntax to use near '; ' at line 1

Huh? If somebody would be so kind to point to me the correct syntax, that would be great. I've been using MYSQL Server version 5.0.27.

Much appreciated, Garyc