RE: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
I had that suspicion that I was only calling it for the last query. Thank you for confirming and for the code! Much appreciated. Stuart --- Graham Cossey <[EMAIL PROTECTED]> wrote: > Stuart, you are calling your rollback function only > if $result is false. > > This check you are performing at

RE: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Graham Cossey
Stuart, you are calling your rollback function only if $result is false. This check you are performing at the end of performing your 3 queries, each of which update $result. The net result here is that you will only call rollback() if the 3rd query results in false. I would create another functio

Re: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
See Interspersed: --- Martín Marqués <[EMAIL PROTECTED]> wrote: > I was tryiong to generate a validation that would > fail with certain inserts > (or modification of a register). Using more then 25 > characters in the second > field would yield the same result. Got that and yes, for my pages ,

Re: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread =?iso-8859-1?q?Mart=EDn_Marqu=E9s?=
El Sáb 16 Oct 2004 11:36, Stuart Felenstein escribió: > I think you are adding a conditonal /validaton > statement as the constraint ? More then x characters > will generate an error. I was tryiong to generate a validation that would fail with certain inserts (or modification of a register). Usin

Re: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
I think you are adding a conditonal /validaton statement as the constraint ? More then x characters will generate an error. My understaning is an error in mysql transaction will rollback should rollback the entire set of transactions. error handling for each statement- values will be coming from

Re: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread =?iso-8859-1?q?Mart=EDn_Marqu=E9s?=
El Sáb 16 Oct 2004 09:52, Stuart Felenstein escribió: > My statements are all working but I'm not sure if > things are set up correctly. I say this because at > one point the first $query failed, yet the rest of > inserts wre committed. Now I believe I need to set > autocommit to 0 , yet the quer