Re: [RDBO] dbh caching

2007-04-14 Thread Perrin Harkins
On 4/14/07, Bill Moseley <[EMAIL PROTECTED]> wrote: > So when that die is called the transaction is rolled back and nothing > sub outer() or do_stuff_and_send_mail() did is in the database. But, > the mail still got sent (probably saying something happened that > didn't.) It sound like you want a

Re: [RDBO] using functions

2007-04-14 Thread Bill Moseley
On Sat, Apr 14, 2007 at 01:16:10AM -0400, Jonathan Vanasco wrote: > is there a way to get Rose to search based on functions? > > ie: > bad > SELECT * FROM useraccount WHERE email = ? > good > SELECT * FROM useraccount WHERE lower(email) = lower(?) How about

Re: [RDBO] dbh caching

2007-04-14 Thread Bill Moseley
On Sat, Apr 14, 2007 at 12:41:55AM -0400, Perrin Harkins wrote: > > If you have one sub: > > > > do_stuff_and_send_mail { > > > > { > > local $dbh->{AutoCommit} = 0; > > $object->do_stuff; > > } # commit (unless nested) > > > > send_mail( "do_stuf