List:MySQL++« Previous MessageNext Message »
From:Steve Roberts Date:June 14 2005 6:23pm
Subject:RE: Locking using INNODB
View as plain text  
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 = conn.query();
q << <update of some sort>;
mysqlpp::ResNSel res = q.execute();

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

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