On Mon, Jul 14, 2008 at 05:13:58PM +0100, Dermot wrote:
> Hi,
>
> I am sure this is a simple task but I don't appear to be getting it.
>
> t1 has a column in which I store the id for the members of t2
>
> I can do this:
>
> my $data_from_t1 = $c->model('MyDB::MyData')->find({'sub_id' => $id});
>
> and I can retrieve the other table object from $data_from_t1 by
>
> $data_from_t2 = $data_from_t1->t1_column_ref
>
> But what if, in the process of updating t1, I want to update a field
> in a related record in t2. I can't seem to find a way to do that.
>
> I have tried
>
> $data_from_t2->field_to_update = 1;
> $data_from_t2->update;
> $data_from_t1_update;
$data_from_t2->field(1);
$data_from_t2->update;
or
$data_from_td->update({ field => 1 });
just like on any DBIx::Class::Row object.
>
> Can someone point me in the right direction?
> Thanx,
> Dp.
>
> _______________________________________________
> List: http://lists.scsys.co.uk/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]
--
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director http://www.shadowcat.co.uk/catalyst/
Shadowcat Systems Ltd. Want a managed development or deployment platform?
http://chainsawblues.vox.com/ http://www.shadowcat.co.uk/servers/
_______________________________________________
List: http://lists.scsys.co.uk/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]
