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 query

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 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). Using

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 , they

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 the