Re: [PHP] MySQL -- finding whether there's a transaction started

2009-04-26 Thread Lester Caine
Bogdan Stancescu wrote: Hello list, I'm developing a library and would need to know if the code calling my library has already started a MySQL transaction or not. I want to know whether I should start one or use savepoints instead -- starting a transaction if one is already in progress commits t

Re: [PHP] MySQL -- finding whether there's a transaction started

2009-04-26 Thread Chris
Bogdan Stancescu wrote: On 24-Apr-09 03:45, Chris wrote: I don't think mysql has any way of finding that out. If you're using an abstraction layer, it's easy enough in code - though rollback's are a little harder - should they do a complete rollback or just to a savepoint? Thank you for taking

Re: [PHP] MySQL -- finding whether there's a transaction started

2009-04-24 Thread Bogdan Stancescu
On 24-Apr-09 03:45, Chris wrote: > I don't think mysql has any way of finding that out. If you're using an > abstraction layer, it's easy enough in code - though rollback's are a > little harder - should they do a complete rollback or just to a savepoint? Thank you for taking the time to sketch th

Re: [PHP] MySQL -- finding whether there's a transaction started

2009-04-23 Thread Chris
Bogdan Stancescu wrote: Hello list, I'm developing a library and would need to know if the code calling my library has already started a MySQL transaction or not. I want to know whether I should start one or use savepoints instead -- starting a transaction if one is already in progress commits t

[PHP] MySQL -- finding whether there's a transaction started

2009-04-23 Thread Bogdan Stancescu
Hello list, I'm developing a library and would need to know if the code calling my library has already started a MySQL transaction or not. I want to know whether I should start one or use savepoints instead -- starting a transaction if one is already in progress commits the existing transaction, a