Hi and happy new year, I am stuck with my issue using "default_column" in my yml (see below for the error message). The thread "many_to_many save_to_model & defaults_from_model" from January 2008 does not seem to help me. Right now it seems that I have two options: Either don't use "default_column" and get the "ambiguous" error message when calling the edit action, or use "default_column" and get the "Unknown column" error message when trying to submit the edited form. Both cases do not help on.
Any hints? Thanks in advance! -------- Original-Nachricht -------- > Datum: Mon, 08 Dec 2008 14:03:35 +0100 > Von: "Jens Schwarz" <[email protected]> > An: [email protected] > Betreff: Re: [html-formfu] "Column \'id\' in field list is ambiguous" > Hi Carl, > > -------- Original-Nachricht -------- > > Datum: Thu, 4 Dec 2008 08:38:34 +0000 > > Von: "Carl Franks" <[email protected]> > > An: "HTML Form Creation, Rendering and Validation Framework" > <[email protected]> > > Betreff: Re: [html-formfu] "Column \'id\' in field list is ambiguous" > > It looks like it may be the same issue. > > If you follow the responses in that thread, you'll see it was fixed - > > though you'll need to make a slight change to your form config file. > > hmm, it seems I am missing something: I now have edited my edit.yml from > ... > > - type: Text > name: name > - type: Select > name: genres > > ... to ... > > - type: Text > name: name > - type: Select > name: genres > model_config: > default_column: me.genres_id > > (By the way: "db: default_column: me.genres_id" as mentioned in the > January-thread did not work for me - I did not find this "db" attribute > mentioned.) > > Now I can call my edit action in Catalyst, but when I want to save the > edited data (i.e. press the 'Submit' button), I get a new error message: > > DBIx::Class::ResultSet::count(): DBI Exception: DBD::mysql::st execute > failed: Unknown column 'me.genres_id' in 'where clause' [for Statement "SELECT > COUNT( * ) FROM genres me WHERE ( me.genres_id IN ( ? ) )" with > ParamValues: 0='2'] -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger _______________________________________________ HTML-FormFu mailing list [email protected] http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
