I havent tried multiples yet. James there are several
problems with 2.1.1 some of which I didnt identify I
hope you have all the patches. A major one I hit was
the memory leak a real charmer.
Cheers,
Garyc
--- James Vanns <james.vanns@stripped>
wrote:
> 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.
>
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
>
http://lists.mysql.com/plusplus?unsub=1
>
>
