http://dev.mysql.com/doc/refman/5.0/en/mysql-real-query.html
"Normally, the string must consist of a single SQL statement and you
should not add a terminating semicolon (';') or \g to the statement."
remove the semi-colon at the end of your query
jon
On 16/02/07, gary clark <burslem2001@stripped> wrote:
> 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
>
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe: http://lists.mysql.com/plusplus?unsub=1
>
>
