Thanks Ben and John. David
________________________________ De: John Romkey <[email protected]> Para: The elegant MVC web framework <[email protected]> Enviado: mar,23 marzo, 2010 19:30 Asunto: Re: [Catalyst] [DBIx::Class::ResultSet ] 'update' with 'where' clause On Mar 23, 2010, at 2:15 PM, David wrote: Hi, > >I can't find how to set 'where' clause in an update. I only want to update >rows depending on a condition. Is that possible? >I haven't this option in ResultSet documentation. > >I try like next, but it doesn't work. It updates all table rows. > >$c->model('DB::Test')->update({'lang' => $lang->first->id},{where => {'id' => >$c->user->get('id')}}); This is really a DBIx::Class question and belongs on that list. However.. you perform update on a resultset. $c->model() returns a resultset with no where clause. So get the resultset that you need with search and then call update() on that. $c->model('DB::Test')->search({ 'id' => $c->user->get('id') })->update({'lang' => $lang->first->id}); - john romkey http://www.romkey.com/
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
