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