set_sql problem

[prev] [thread] [next] [Date index for 2004/11/05]

Hi,

I'm having a strange little problem  with a set_sql statement and am
wondering if someone here might be able to help.

I have a:

__PACKAGE__->set_sql(blah=>qw{
SELECT now()::date < date_col::date 
FROM __TABLE__
WHERE id=?
});


which I am calling like this:

my $val = $obj->sql_blah->select_val(1);

which keeps giving:

Can't locate object method "date" via package "db_now()::date" at
/usr/lib/perl5/vendor_perl/5.6.1/Ima/DBI.pm line 417.

(note: I get a similar error ( can't locate db_*)  no matter what
columns I am selecting ... )

while my connection was created via: 

Class->connection('dbi:Pg:dbname=dbname','user','login');

when I dump db_Main:

$VAR1 = bless( {}, 'Ima::DBI::db' );



???

-james