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