[Dbix-class] Oracle Built-In Functions

[Андрей Костенко]

$rs->date_updated( \‘SYSDATE’ );

On Wed, Aug 4, 2010 at 1:25 PM, Duncan Garland
<Duncan.Garland at motortrak.com> wrote:
> Hi,
>
>
>
> I’m struggling to persuade DBIx::Class to use simple Oracle built-ins such
> as SYSDATE, DECODE and NVL.
>
>
>
> Eg UPDATE table1 SET date_updated = SYSDATE, destination = NVL(
> $destination, ‘home’ ) WHERE ... ;
>
>
>
> $rs->date_updated( ‘SYSDATE’ );
>
>
>
> Doesn’t work, nor can any variation on a theme that I can think of.
>
>
>
> I’m sure it must be possible and I’m sure it must be in the docs, but I
> can’t find it.
>
>
>
> Can anybody help?
>
>
>
> Regards
>
>
>
> Duncan
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>