$rs->date_updated( \‘SYSDATE’ ); On Wed, Aug 4, 2010 at 1:25 PM, Duncan Garland <[email protected]> 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/[email protected] >
_______________________________________________ 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/[email protected]
