[Dbix-class] Calling functions on UPDATE/INSERT?

Cory Spencer cspencer at sprocket.org
Fri Oct 13 20:50:46 CEST 2006


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?

Regards,

Cory Spencer



More information about the Dbix-class mailing list