Cory Spencer wrote:
> Is it possible to call database functions/stored procedures on an UPDATE
> or an INSERT statement? I've found documentation describing how to do it
> in a SELECT, but not the former two.
>
> For example, on the MySQL database I'm currently using, I'd like to be
> able to update a last_modified field with the return value from the NOW()
> function. How would one do this with DBIx::Class?
guess it is.
$rs->update( {
last_modified => \"NOW()"
} );
>
> Regards,
>
> Cory Spencer
>
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
