RE: Locking using INNODB

#1

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
}

Quote:

-----Original Message-----
From: Ger Hayden [mailto:ghayden (AT) iol (DOT) ie]=20
Sent: Monday, June 13, 2005 12:51 PM
To: plusplus (AT) lists (DOT) mysql.com
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?unsu...) f5 (DOT) com
=20
=20

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Locking using INNODB

mailing.database.mysql-plusplus mailing.database.mysql-plusplus

RE: Locking using INNODB - 06-14-2005 , 01:23 PM