See Interspersed:
--- Martín Marqués <martin@xxxxxxxxxxxxxxx> 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 won't even
arrive at the transaction page until all validations
have been passed.
> Why don't you try using PEAR::DB, set autocommit to
> false and work like this:
>
> // supose $db is a database objet which already has
> a conection made
> $db->autocommit(false);
>
> $db->query("INSERT INTO ...");
> $db->query("INSERT INTO ...");
> $db->query("INSERT INTO ...");
>
> $db->commit();
Isn't that what I'm doing with PHP ? I'm not ready to
jump into PEAR until I have a better understanding of
PHP plain but I think it's worth looking into . I've
also considered Adodb with "smart transactions".
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
