RE: [Dbix-class] select from dual

2008-05-13 Thread Hartmaier Alexander
It's DBIC, not DBIx, which is a namespace! You might fetch $dbh and do it with a DBI method or create a dual table class. I think this was discussed on the list a few month ago...yes, the thread was started by Richard Cox on the 9.11.2007. He even submitted a doc patch which Jess applied on the

Re: [Dbix-class] Select From Dual (Again)

2007-11-10 Thread Richard Cox
Hi, I've played around a bit more now and am loving HashRefInflator but will prob stick to doing $obj-get_column('sysdate'); More than happy to contribute so here's a brief recipe for selecting from dual, feel free to remove the Note: if people think it's patronizing ;) Cheers Rick =head3

Re: [Dbix-class] Select From Dual (Again)

2007-11-09 Thread Matt S Trout
On Fri, Nov 09, 2007 at 03:11:25PM +, Richard Cox wrote: So all that's cool but I hit a roadblock if I want to select more than one column at a time because we only have one 'dummy' column in our table class so it gets autoviv'd my @rs = $schema-resultset('Dual')-search(undef, {