Hi Charlie,

-------- Original-Nachricht --------
> Datum: Thu,  4 Dec 2008 16:32:39 +1100
> Von: Charlie Garrison <[EMAIL PROTECTED]>
> An: "HTML Form Creation,      Rendering and Validation Framework" 
> <html-formfu@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 <[EMAIL PROTECTED]> 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

_______________________________________________
HTML-FormFu mailing list
HTML-FormFu@lists.scsys.co.uk
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu

Reply via email to