Good afternoon,
On 4/12/08 at 6:13 AM +0100, Jens Schwarz <[EMAIL PROTECTED]> wrote:
If I now want to edit a band, I get this "ambiguous" error message:
DBIx::Class::ResultSetColumn::all(): DBI Exception:
DBD::mysql::st execute failed: Column 'id' in field list is
ambiguous [for Statement "SELECT id FROM bands_has_genres me
JOIN genres genres_id ON ( genres_id.id = me.genres_id ) WHERE
( me.bands_id = ? )" with ParamValues: 0='7'] at
/opt/aperl/ActivePerl-5.10/site/lib/HTML/FormFu/Model/DBIC.pm
line 200
What am I doing wrong?
I had a similar problem and I had to remove the 'id' column from
the join table, and instead used a compound primary key based on
the related keys.
For unrelated reasons I'd prefer to have an id column, but I
couldn't get it to work. I'd love to hear of a proper fix which
allows the join table to have the id column.
Charlie
--
Charlie Garrison <[EMAIL PROTECTED]>
PO Box 141, Windsor, NSW 2756, Australia
O< ascii ribbon campaign - stop html mail - www.asciiribbon.org
http://www.ietf.org/rfc/rfc1855.txt
_______________________________________________
HTML-FormFu mailing list
[email protected]
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
