On 4 August 2010 22:25, 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 > I do most of my development against Oracle, although I try to make my code DB generic where possible. If you use a DateTime object rather than sysdate, DBIC will deflate it for you. Of course, creating the new object is slower than simply using sysdate, so I guess it depends how speed sensitive your app is...
_______________________________________________ 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]
