On 5/3/06, Guillermo Roditi <[EMAIL PROTECTED]> wrote:
I have a table which includes a blob and a field for a hash of that blob.
I'd like to make atrigger that automatically updates the hash every time the
blob is changed, so i figured i would do it with a trigger. I figured the
best way to do it would be by overloading new, but that doesnt work...

You only need to add the trigger to the column once.  Do it in your
class setup after you initialize():

   package Cantella::PaperKiller::DB::UserPropTypeBin
   ...
   __PACKAGE__->meta->initialize;
   __PACKAGE__->meta->column('whatever')->add_trigger(...);
   ...

-John


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to