Re: [RDBO] Beginner q. on date

2007-03-15 Thread James Masters
Thanks to all who answered. Aagh - now I have 2 opposing answers. But I enjoy a debate. 8o) I don't quite see this point around special checks being required if I make "no date" equal NULL. If I choose the NULL route, then I will likely need to say if (!defined($date)) in my code. But if I cho

Re: [RDBO] Beginner q. on date

2007-03-15 Thread Ron Savage
James Masters wrote: Hi James > But if I choose the NOT NULL route, then surely I will still need a special > check i.e. if ($date ne '-00-00') > > To me the latter sounds like a slighly more contrived check, no? No. It's not that simple. -- Ron Savage [EMAIL PROTECTED] http://savage.net.

Re: [RDBO] Beginner q. on date

2007-03-15 Thread Danial Pearce
> But if I choose the NOT NULL route, then surely I will still need a special > check i.e. if ($date ne '-00-00') RDBO uses DateTime to handle it's objects I believe. YMMV but I think it may handle the -00-00 case under the hood. regards, Danial --

Re: [RDBO] Beginner q. on date

2007-03-15 Thread John Siracusa
On 3/15/07 6:14 AM, Danial Pearce wrote: >> But if I choose the NOT NULL route, then surely I will still need a special >> check i.e. if ($date ne '-00-00') > > RDBO uses DateTime to handle it's objects I believe. YMMV but I think > it may handle the -00-00 case under the hood. -00-00

[RDBO] Catalyst::Plugin::Session::Store::DBI

2007-03-15 Thread Peter Karman
The latest (0.09) CPAN version of this Catalyst plugin now contains support for RDBO. You can specify a RDBO class name as the 'dbi_dbh' config param, and it will return the dbh like: My::RDBO::Session->new->dbh This is similar to the DBIC and CDBI support in that same module. -- Peter Karm

Re: [RDBO] Catalyst::Plugin::Session::Store::DBI

2007-03-15 Thread John Siracusa
On 3/15/07 9:14 AM, Peter Karman wrote: > The latest (0.09) CPAN version of this Catalyst plugin now contains support > for RDBO. You can specify a RDBO class name as the 'dbi_dbh' config param, and > it will return the dbh like: > > My::RDBO::Session->new->dbh Shouldn't that be this instead?

Re: [RDBO] Catalyst::Plugin::Session::Store::DBI

2007-03-15 Thread Peter Karman
John Siracusa scribbled on 3/15/07 8:48 AM: > On 3/15/07 9:14 AM, Peter Karman wrote: >> The latest (0.09) CPAN version of this Catalyst plugin now contains support >> for RDBO. You can specify a RDBO class name as the 'dbi_dbh' config param, >> and >> it will return the dbh like: >> >> My::RD