Re: [Dbix-class] convention for naming primary keys to avoidambiguousselects

2008-11-25 Thread Octavian Rasnita
From: Noel Burton-Krahn [EMAIL PROTECTED] This is a reasonable query: load a person with address by the person's id. The 'id' column is unambiguous in the search call. However, DBIx generates ambiguous SQL: DBIx::Class::ResultSet::count(): DBI Exception: DBD::mysql::st execute failed: Column

Re: [Dbix-class] convention for naming primary keys to avoidambiguousselects

2008-11-25 Thread Peter Rabbitson
Octavian Rasnita wrote: From: Noel Burton-Krahn [EMAIL PROTECTED] This is a reasonable query: load a person with address by the person's id. The 'id' column is unambiguous in the search call. However, DBIx generates ambiguous SQL: DBIx::Class::ResultSet::count(): DBI Exception:

Re: [Dbix-class] convention for naming primary keys to avoidambiguousselects

2008-11-25 Thread Noel Burton-Krahn
On Tue, Nov 25, 2008 at 2:06 PM, Peter Rabbitson [EMAIL PROTECTED] wrote: Octavian Rasnita wrote: From: Noel Burton-Krahn [EMAIL PROTECTED] By the way, does anyone know what happends if a secondary table is named me? The name of the table is irrelevant as they are all aliased anyway. If