[html-formfu] "Column 'id' in field list is ambiguous"

[Jens Schwarz]

Hi Charlie,

-------- Original-Nachricht --------
> Datum: Thu,  4 Dec 2008 16:32:39 +1100
> Von: Charlie Garrison <garrison at zeta.org.au>
> An: "HTML Form Creation, 	Rendering and Validation Framework" <html-formfu at lists.scsys.co.uk>
> Betreff: Re: [html-formfu] "Column \'id\' in field list is ambiguous"

> Good afternoon,
> 
> On 4/12/08 at 6:13 AM +0100, Jens Schwarz <blacky6767 at gmx.de> wrote:
> 
> >If I now want to edit a band, I get this "ambiguous" error message:
> > (...)
> 
> 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.

Yes, similar situation here.

> 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.

Same here: A co-worker of mine (DB admin) told me that using 'id' as single primary key instead of a compound primary key would be "best practice".
-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger