UPDATE routine giving exception

[gary clark]

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