Hello List, I used to have an "id INTEGER PRIMARY KEY" column in every table. Now I am using DBIC and repeatedly run into this kind of error.
SELECT me.id, me.title, me.artist FROM cds me WHERE ( me.artist = ? ): '2' SELECT me.id, me.title, me.artist, artist.id, artist.name FROM cds me JOIN artists artist ON ( artist.id = me.artist ) WHERE ( id = ? ): '1' DBI Exception: DBD::SQLite::db prepare_cached failed: ambiguous column name: id(1) at dbdimp.c line 271 [for Statement "SELECT me.id, me.title, me.artist, artist.id, artist.name FROM cds me JOIN artists artist ON ( artist.id = me.artist ) WHERE ( id = ? )"] at /usr/local/share/perl/5.8.8/DBIx/Class/Schema.pm line 954 is it best(-DBIC)-practice to name primary keys <tablename>_id to avoid these errors or is there some other solution? thanks in advance David _______________________________________________ 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/dbix-class@lists.scsys.co.uk