On 13 January 2011 12:38, Gabor HALASZ <halas...@freemail.hu> wrote: > I think, I have same problem with my form. My config is: > > <elements> > type Checkboxgroup > name actions > label_loc Action > reverse_group 0 > <constraints> > type AutoSet > </constraints> > <model_config> > resultset Action > id_column id > label_column action > <condition> > <id> > > 1 > </id> > </condition> > <attributes> > <order_by> > -asc action > </order_by> > </attributes> > </model_config> > </elements> > > The form and model->default_values works well, but model->create/update > generates a wrong query: > > DBI Exception: DBD::mysql::st execute failed: Column 'id' in where clause is > ambiguous [for Statement "SELECT map_actions.id, map_actions.action, > map_actions.method FROM Role_Action me JOIN Action map_actions ON > map_actions.id = me.action_id WHERE ( ( id > ? AND me.role_id = ? ) )" with > ParamValues: 0="1", 1="2"] at > /usr/local/lib/perl5/site_perl/5.10.1/DBIx/Class/Schema.pm line 1061 > > Without the condition, the create/update works well. The resultset > relationship is many_to_many and my Model::DBIC newer than the linked > revision (0.08002). What about this?
Hi, Tracing the code, I think the only reason default_values() isn't dying is because the 'condition' isn't being used by it at all. I think you need to change the "id" in the config to either "me.id" or "map_actions.id", as appropriate. Carl _______________________________________________ HTML-FormFu mailing list HTML-FormFu@lists.scsys.co.uk http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
