transaction logging

[jimfog]

I have set up a transaction in which 2 queries are performed, 2 inserts having to do with user registration.

Suppose that one of the queries fails, how am I going to learn which one failed?

 

Can exceptions help me here?

[birbal]

If you want to log it in background, you can use exception with specific message and/or the sql dump in the message. and use a specific exception handler for that particular type of exception that handler will dump the data to flat file or inform the admin or any thing you want to do with it.