Thanks for the pointer. I had defined the foreign key relationships
within MySQL and relied on wsdsis_create.pl model DB DBIC::Schema etc
etc to build the model and define these relations, but it seems that
can't be quite be trusted! Anyway, I'm taking them out of the db and
manually putting them into the respective models and it's working now.
Thanks again!
Steve
Moritz Onken wrote:
Am 11.05.2009 um 23:43 schrieb Steve Rippl:
__PACKAGE__->belongs_to(
"locationid",
"WsdSis::Schema::Result::Location",
{ locationid => "locationid" },
);
should be
__PACKAGE__->belongs_to(
"locationid",
"WsdSis::Schema::Result::Location",
);
or
__PACKAGE__->belongs_to(
"locationid",
"WsdSis::Schema::Result::Location",
{ 'foreign.locationid' => "self.locationid" },
);
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive:
http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
--
Steve Rippl
Technology Director
Woodland School District
360 225 9451 x326
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
