Hi, Jon.
I tried that and it worked perfectly.
I'll make a small, simple but fully functional example and add it to the wiki
this weekend.
Thanks!
Cheers,
bill
>________________________________
> From: jmo mlists <jmo.mli...@gmail.com>
>To: The elegant MVC web framework <catalyst@lists.scsys.co.uk>
>Sent: Wednesday, August 22, 2012 1:12 PM
>Subject: Re: [Catalyst] many to many join with multicolumn primary key
>
>
>Hi,
>
>
>On Tue, Aug 21, 2012 at 5:10 PM, bill hauck <wbha...@yahoo.com> wrote:
>
>Hi.
>>
>>Posted this to the DBIx::Class maillist, but not getting an traction there.
>>Perhaps someone else has run into this issue on a Catalyst app.
>>
>>
>>I need to connect two tables through a relation table for a many_to_many.
>>The issue I'm running into is that one of the tables has a composite primary
>>key. I'm using this in a Catalyst application through a Template Toolkit
>>template.
>>
>>So, before going through the whole thing, is it possible to have a composite
>>primary key used in many to many? If not, any suggestions on a workaround?
>>
>>If it is possible, here's my setup. The user will submit issues into
>>complexity_submission. A trigger will create a duplicate entry in table
>>complexity giving the unique post id and then a version of the post.
>>
>>Tables, trigger, Schema::Result relations listed, and template below.
>>
>>
>
>Did you try the way suggested here?
>http://grokbase.com/t/sc/dbix-class/071g80741a/multi-column-primary-foreign-key
>
>
>/Jon
>
>
>_______________________________________________
>List: Catalyst@lists.scsys.co.uk
>Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
>Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
>Dev site: http://dev.catalyst.perl.org/
>
>
>
_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
