Hi,
I have 2 dependent tables with the following structure:
create table communique(
id int unsigned not null auto_increment primary key,
last_modified timestamp not null default current_timestamp,
type varchar(255) not null default ""
) engine=InnoDB default charset=utf8;
create table aga(
id int unsigned not null auto_increment primary key,
communique int unsigned not null,
detail text,
unique index(communique),
constraint foreign key(communique) references communique(id) on delete
cascade
) engine=InnoDB default charset=utf8;
And I want to use Catalyst::Controller::HTML::FormFu to update both tables.
I have created the following form:
<model_config>
resultset Communique
</model_config>
<elements>
name last_modified
type DateTime
label Last modified:
</elements>
<elements>
name type
type Text
label Type:
</elements>
<elements>
name agas.detail
type Textarea
label Details:
</elements>
There is a relation named "agas" between communique and aga tables and I was
hoping that by using agas.detail, it would get/set the value from that
field, however unfortunately HTML::FormFu doesn't have this feature
(although it would be great).
It gave the following error on form rendering:
"Caught exception in Fu::Controller::Com->add "element names may not contain
periods or square brackets
see documentation on nested_names() for details"
I have searched for documentation about "nested_names" but I couldn't find
anything.
Maybe HTML::FormFu doesn't support multiple table updates by just using a
config file, but I hope there is a more elegant way of doing these updates
than getting the values from the form and making the DBIC updates manually.
Does anyone know if nested_names() and the other related methods can help me
to update more tables from a single form?
Thank you for any information regarding this.
Octavian
_______________________________________________
HTML-FormFu mailing list
[email protected]
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
