-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 >Will a $sth->execute() > of a "SELECT ... FOR UPDATE" statement allow me to update the selected > records using > $uth->execute( ... ) > if $sth and $uth are both created/prepared from the same database handle > "$dbh"? You are allowed to update either way, but the lock created by the first execute will be in place for the second, as long as those statement handles are from the same $dbh (database handle). In general, connecting via DBI always gives you one connection unless you explicitly create a second one by calling DBI->connect. - -- Greg Sabino Mullane greg@xxxxxxxxxxxx End Point Corporation PGP Key: 0x14964AC8 200707181533 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFGnmspvJuQZxSWSsgRAxjIAJ0TRN5bTs9s1/Z3/YC/rzGdpEhWiACg11Ca sdXpTplc1laTXywTrd+8nBw= =5iA0 -----END PGP SIGNATURE-----
