List:MySQL++« Previous MessageNext Message »
From:James Vanns Date:February 19 2007 10:51am
Subject:Re: UPDATE routine giving exception
View as plain text  
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.

Thread
Two bugs in 2.2.0Joseph Artsimovich12 Feb
  • Column sizesgary clark12 Feb
    • Re: Column sizesWarren Young13 Feb
      • Re: Column sizesgary clark16 Feb
        • Re: Column sizesWarren Young16 Feb
          • Re: Column sizesgary clark16 Feb
            • UPDATE routine giving exceptiongary clark16 Feb
              • Re: UPDATE routine giving exceptionJonathan Wakely17 Feb
                • Re: UPDATE routine giving exceptiongary clark18 Feb
                  • Re: UPDATE routine giving exceptionJames Vanns19 Feb
                    • Re: UPDATE routine giving exceptiongary clark19 Feb
                      • Re: UPDATE routine giving exceptiongary clark23 Feb
                        • Re: UPDATE routine giving exceptionWarren Young23 Feb
                          • Re: UPDATE routine giving exceptiongary clark23 Feb
                            • Re: UPDATE routine giving exceptionWarren Young24 Feb
                              • Re: UPDATE routine giving exceptionIan Miller24 Feb
                              • Re: UPDATE routine giving exceptiongary clark24 Feb
                                • Re: UPDATE routine giving exceptiongary clark28 Feb
                                  • Re: UPDATE routine giving exceptionWarren Young1 Mar
                                    • Re: UPDATE routine giving exceptiongary clark1 Mar
                                    • Re: UPDATE routine giving exceptiongary clark19 Mar
                                      • Re: UPDATE routine giving exceptionWarren Young19 Mar
                                        • Re: UPDATE routine giving exceptiongary clark19 Mar
                                          • Re: UPDATE routine giving exceptionWarren Young19 Mar
                                            • Re: UPDATE routine giving exceptiongary clark20 Mar
  • Re: Two bugs in 2.2.0Warren Young20 Feb
    • Re: Two bugs in 2.2.0Joseph Artsimovich20 Feb
      • Re: Two bugs in 2.2.0Jonathan Wakely20 Feb
        • Re: Two bugs in 2.2.0Joseph Artsimovich20 Feb
          • Re: Two bugs in 2.2.0Jonathan Wakely20 Feb
            • Re: Two bugs in 2.2.0Joseph Artsimovich20 Feb
              • Re: Two bugs in 2.2.0Jonathan Wakely20 Feb
        • Re: Two bugs in 2.2.0Warren Young20 Feb