Re: [Catalyst] update record with unique ID

2007-04-09 Thread Danny Warren
Michael Higgins wrote: Right. I want to update the record as defined by that primary key. I guess I found the answer: ->update_or_create({ Seems to do the trick, checking for unique and updating with other values posted. Too easy, as usual. ;-) Cheers, Ignore my response as well then...

RE: [Catalyst] update record with unique ID

2007-04-09 Thread Michael Higgins
> -Original Message- > From: Christopher H. Laco [mailto:[EMAIL PROTECTED] > > Michael Higgins wrote: > > Hello, Cat-list-ers, > > > > Here's a pared-down version of my question, hoping it's an easy one: > > > > ERROR: > > "DBIx::Class::ResultSet::update(): Error executing 'UPDATE ... >

Re: [Catalyst] update record with unique ID

2007-04-09 Thread Danny Warren
Christopher H. Laco wrote: Michael Higgins wrote: Hello, Cat-list-ers, Here's a pared-down version of my question, hoping it's an easy one: ERROR: "DBIx::Class::ResultSet::update(): Error executing 'UPDATE ... Duplicate entry '140949' for key 1 at QUESTION: How do we specify UPDATE ... blah

Re: [Catalyst] update record with unique ID

2007-04-09 Thread Christopher H. Laco
Michael Higgins wrote: > Hello, Cat-list-ers, > > Here's a pared-down version of my question, hoping it's an easy one: > > ERROR: > "DBIx::Class::ResultSet::update(): Error executing 'UPDATE ... > Duplicate entry '140949' for key 1 at > > QUESTION: > How do we specify UPDATE ... blah WHERE (ID=