I have a database where the primary key is defined over several columns.
I have used the Class:DBI method to define by primary key
MyDB::Results->columns(Primary => qw/version resolution precision/);
MyDB::Results->columns(Other => qw/a b c/);
My problem is in constructing the one to one join with another table.
When the primary key is a single column called id, there is no problem
MyDB::Results->has_a(suite => "MyDB::Suites");
Now I want to join two tables that use the same multi column primary key
How to I define the join columns. In the example above, I just use the
column
name, suite but cannot use that for several columns. And what gets displayed
in the join link, as it cannot simply display the column contents?
Do I need to have a named key. (I don't think you can alter the name of the
primary key).
Any help much appreciated.
Kim
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Maypole-users mailing list
Maypole-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/maypole-users
