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
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
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,
{