Re: set_sql problem

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

Y00R0B0T wrote:
> 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=?
> });

Well, first off, qw{} will give you back a list, which i'm sure you 
don't want. What I suspect is that you are using qq() instead. If this 
is the case then variable interpolation might be causing perl to try and 
find the now()::date package var.

Btw, what does '::date' mean in SQL ?

        -- 
        Michael Peters
Developer
Plus Three, LP