To be honest I rolled back to 2.1.1 almost as soon as I upgraded 2.2.0 due a change not
apparent in the Changelog. I saw such a catastrophic (damn near every statement - thats
~1000/s) no. of failures to execute blah blah (majority are UPDATEs) I had to reinstall
the old .so. Never had any problems with that one. However, it could well be because all
statements executed on the server with MySQL++ end in a semicolon (';'). This had never
been a problem before. I have not yet found time to test another installation with this
modification (removing the ';'). How are multi-queries handled now if a semicolon is
deemed erroneous?
Just my tuppence.
Jim
----- Original Message -----
From: "gary clark" <burslem2001@stripped>
To: plusplus@stripped
Sent: 18 February 2007 01:59:58 o'clock (GMT) Europe/London
Subject: Re: UPDATE routine giving exception
Thanks for the response.
With the 2.2.0 mysql++ build in Windows I see a
failure.
query << "UPDATE clienttransfer SET seq=1";
I still see a failure to perform an update, is anybody
else seeing this problem?
Much appreciated,
Garyc
--- Jonathan Wakely <mysql@stripped> wrote:
>
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
> >
> >
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
>
http://lists.mysql.com/plusplus?unsub=1
>
>
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=1
--
James Vanns
Systems Programmer
Framestore CFC Ltd.
