Re: [RDBO] Still fighting with transactions

2007-08-16 Thread Tim Bunce
On Wed, Aug 15, 2007 at 10:17:07PM -0400, John Siracusa wrote: On 8/15/07 10:08 PM, Graham Barr wrote: On Aug 15, 2007, at 7:56 PM, John Siracusa wrote: The only dbh attributes that get set in init_dbh() after the DBI-connect() call are the ones that don't (apparently?) work if passed as

Re: [RDBO] Still fighting with transactions

2007-08-15 Thread Tim Bunce
On Wed, Aug 15, 2007 at 01:06:01PM -0500, Graham Barr wrote: Rose::DB does not know that the $dbh it get back from connect is not a newly connected handle. As a result is still goes ahead and calls init_dbh which will set all the dbh attributes to the defaults. The standard approach I

Re: [RDBO] How to register a db using DBI::Proxy?

2007-08-09 Thread Tim Bunce
On Thu, Aug 09, 2007 at 07:42:36AM -0400, John Siracusa wrote: On 8/9/07 6:13 AM, Michael Lackhoff wrote: I get this error message: Attempt to change driver from 'oracle' to 'proxy' detected. The driver cannot be changed after object creation. at test02.pl line 8 Is it possible to

Re: [RDBO] Read-only objects

2007-04-05 Thread Tim Bunce
On Wed, Apr 04, 2007 at 09:20:30AM -0700, Randal L. Schwartz wrote: Here's what I did for my readonly class, based on discussions with jcs six months ago: sub insert { die cannot insert unless our $READWRITE; goto {$_[0]-can(SUPER::insert)}; } Hi Randal. Idle

Re: [RDBO] client out of memory with large table

2007-01-07 Thread Tim Bunce
On Fri, Jan 05, 2007 at 08:26:21PM -0500, Perrin Harkins wrote: Neal Clark wrote: Ideally, I will be making iterators from SQL calls. The SQL will limit the number of rows as best as I can, but there will be times I need to iterate over every row. I read in one of the CPAN docs that

Re: [RDBO] datetime oddness

2006-12-22 Thread Tim Bunce
Hi Dan. Is VC using RDBO? Tim. On Thu, Dec 21, 2006 at 03:45:25PM -0800, Dan Wierenga wrote: When I retrieve a datetime field from a mysql database, it gets a T stuck in between the date and time fields of the return value (for Time, I assume). Is there a way to suppress this and have a