Re: Checking for results from update and inserts ?? Possible ?? - Vijay Ramachandran - com.mysql.lists.plusplus

2 messages in com.mysql.lists.plusplusRe: Checking for results from update ...

From	Sent On	Attachments
gary weideman	09 Oct 2003 07:32
Vijay Ramachandran	09 Oct 2003 08:36

Subject:	Re: Checking for results from update and inserts ?? Possible ??
From:	Vijay Ramachandran (vij...@yahoo-inc.com)
Date:	10/09/2003 08:36:51 AM
List:	com.mysql.lists.plusplus

If you have exceptions enabled, you can catch BadQuery. This is for query failure.

Also, Connection::affected_rows() returns the number of changed rows. Return value of 0 can mean an error, depending on your update query logic (update query can return 0 if nothing matched the select).

Vijay

gary weideman writes:

All,

So does anyone know if there is a way to check for a result of an update or an insert somehow ?

The API++ doc mentions that an object with the result from a non-select query is returned but I'm not sure how to check for the result for an update or insert.