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 ali

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 Exceptio

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: Colu