Hello,
Other than James and myself has anyone else had
problems with the 2.2.0 and it query UPDATE routine on
Windows.
I would really appreciate if somebody else has seen
this problem prior to myself diving into this code.
Much appreciated,
Garyc
--- gary clark <burslem2001@stripped> wrote:
> 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
> >
> >
>
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
>
http://lists.mysql.com/plusplus?unsub=1
>
>
