On 7/4/07 1:01 PM, Jonathan Vanasco wrote:
> i don't need to do a db load, i just want to  generate the sql "UPDATE *table*
> SET count_total = count_total + 1  WHERE id_a = 1 " i'm doing a db load now.
> but i'd like to ditch it.  its not needed.

How about this?

    My::Foo::Manager->update_foos(
      set   => { count => { sql => 'count + 1' } },
      where => [ id => 123 ]);

-John



-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to