List:MySQL++« Previous MessageNext Message »
From:Jonathan Wakely Date:February 17 2007 2:53pm
Subject:Re: UPDATE routine giving exception
View as plain text  
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
>
>
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