From: Steve Roberts
Date: June 14 2005 6:23pm
Subject: RE: Locking using INNODB
List-Archive: http://lists.mysql.com/plusplus/4530
Message-Id: <8AF76A158D6BCE45B90202EE6C9537F1011F5093@exchfour.olympus.f5net.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

If you use the ResNSel object you can check whether or not the query
succeeded AND how many rows were affected:

(note: from memory, details may not be quite right)

mysqlpp::Query q =3D conn.query();
q << <update of some sort>;
mysqlpp::ResNSel res =3D q.execute();

if (!res || res.rows < 1) {
    // query failed
}

> -----Original Message-----
> From: Ger Hayden [mailto:ghayden@stripped]=20
> Sent: Monday, June 13, 2005 12:51 PM
> To: plusplus@stripped
> Subject: Re: Locking using INNODB
>=20
> We have an element of Pilot error here. The update didnt=20
> happen but the query ran successfully updating 0 rows! I need=20
> something like Sqlstate or there abouts.
>=20
> 					GER
>=20
>=20
> --=20
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:   =20
> http://lists.mysql.com/plusplus?unsub=3Ds.roberts@stripped
>=20
>=20