Then you need to dig into SQL::Abstract further:
On Wed, 12 Sep 2007, Mark Lawrence wrote:
UPDATE is another: What if I want the database to add the value of 1 to
every row of a certain column? With SQLA all I have to play with is:
$SQLA->update(ÿÿpeopleÿÿ, \%data);
->update('people', { col1 => \'col1 +1'})
(or similar loop to do all the columns)
As far as I know, there is no way to put the summation into \%data.
Alternatively:
$SQLDB->query(
update => [$person->age],
set => [$person->age->set($persion->age + 1)],
);
Anything that involves functions etc in sqla, just use a scalarref which
interprets as "literal sql".
Jess
_______________________________________________
List: http://lists.rawmode.org/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]
