Re: [Dbix-class] Using update on a resultset with join

2010-05-06 Thread Matt S Trout
On Wed, May 05, 2010 at 12:24:18PM +0200, Peter Rabbitson wrote: Whereas I was expecting SQL like: UPDATE foo me JOIN ( bars bar ON bars.id = me.bar_id ) SET me.exported = 1 WHERE ( me.exported = 0 AND bar.state = 'WA' ) Newer versions address this issue, albeit not with the SQL you

Re: [Dbix-class] Using update on a resultset with join

2010-05-05 Thread Peter Rabbitson
Trevor Leffler wrote: I'm stuck with (at the moment) version 0.08011 of DBIC, so please let me know if a newer version addresses this issue. I'm creating a resultset of source 'Foo', joining against one or more other sources, and then trying to update, assuming that the update would work

[Dbix-class] Using update on a resultset with join

2010-05-04 Thread Trevor Leffler
I'm stuck with (at the moment) version 0.08011 of DBIC, so please let me know if a newer version addresses this issue. I'm creating a resultset of source 'Foo', joining against one or more other sources, and then trying to update, assuming that the update would work against 'Foo' and not the