Re: UPDATE routine giving exception - gary clark - com.mysql.lists.plusplus

33 messages in com.mysql.lists.plusplusRe: UPDATE routine giving exception

From	Sent On	Attachments
Joseph Artsimovich	12 Feb 2007 09:14
gary clark	12 Feb 2007 14:08
Warren Young	12 Feb 2007 16:27
gary clark	16 Feb 2007 09:53
Warren Young	16 Feb 2007 11:26
gary clark	16 Feb 2007 11:34
gary clark	16 Feb 2007 13:17
Jonathan Wakely	17 Feb 2007 06:53
gary clark	17 Feb 2007 17:59
James Vanns	19 Feb 2007 02:51
gary clark	19 Feb 2007 06:17
Warren Young	20 Feb 2007 04:19
Joseph Artsimovich	20 Feb 2007 05:36
Jonathan Wakely	20 Feb 2007 05:47
Joseph Artsimovich	20 Feb 2007 05:54
Jonathan Wakely	20 Feb 2007 06:00
Joseph Artsimovich	20 Feb 2007 06:23
Jonathan Wakely	20 Feb 2007 06:31
Warren Young	20 Feb 2007 06:46
gary clark	23 Feb 2007 12:50
Warren Young	23 Feb 2007 13:08
gary clark	23 Feb 2007 13:15
Warren Young	23 Feb 2007 15:15
Ian Miller	23 Feb 2007 15:32
gary clark	24 Feb 2007 06:48
gary clark	28 Feb 2007 15:00
Warren Young	01 Mar 2007 14:32
gary clark	01 Mar 2007 15:00
gary clark	19 Mar 2007 09:39
Warren Young	19 Mar 2007 13:25
gary clark	19 Mar 2007 13:27
Warren Young	19 Mar 2007 13:34
gary clark	20 Mar 2007 07:12

Subject:	Re: UPDATE routine giving exception
From:	gary clark (burs...@yahoo.com)
Date:	02/23/2007 12:50:37 PM
List:	com.mysql.lists.plusplus

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

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 <jame...@framestore-cfc.com> 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" <burs...@yahoo.com> To: plus...@lists.mysql.com 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 <mys...@kayari.org> 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 <burs...@yahoo.com> 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

your

SQL syntax that corresponds to your MYSQL server version for the right syntax to use near '; '

line

Huh? If somebody would be so kind to point to

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=mys...@kayari.org

-- MySQL++ Mailing List For list archives: http://lists.mysql.com/plusplus To unsubscribe:

http://lists.mysql.com/plusplus?unsub=jame...@framestore-cfc.com

-- James Vanns Systems Programmer Framestore CFC Ltd.

-- MySQL++ Mailing List For list archives: http://lists.mysql.com/plusplus To unsubscribe: