Re: [Maypole] Using MySQL views

2006-12-18 Thread Jay Savage
On 12/9/06, Aaron Trevena <[EMAIL PROTECTED]> wrote: > On 07/12/06, Jay Savage <[EMAIL PROTECTED]> wrote: > > Hi, all! > > > > I'm trying to set up a Maypole app to work with our MySQL database. > > One of the 'tables' isn't a table; it's a view. CDBI::Loader doesn't > > like that very much, becaus

Re: [Maypole] Using MySQL views

2006-12-09 Thread Aaron Trevena
On 07/12/06, Jay Savage <[EMAIL PROTECTED]> wrote: > Hi, all! > > I'm trying to set up a Maypole app to work with our MySQL database. > One of the 'tables' isn't a table; it's a view. CDBI::Loader doesn't > like that very much, because views don't have primary keys, and setup > fails with: > >i

[Maypole] Using MySQL views

2006-12-07 Thread Jay Savage
Hi, all! I'm trying to set up a Maypole app to work with our MySQL database. One of the 'tables' isn't a table; it's a view. CDBI::Loader doesn't like that very much, because views don't have primary keys, and setup fails with: instructors has no primary key at .../Class/DBI/Loader/Generic.pm