In your sitemap inside <map:actions> put:
<map:action name="mod-db-add" src="org.apache.cocoon.acting.modular.DatabaseAddAction">
<descriptor>context://foo/bar/database.xml</descriptor>
<throw-exception>true</throw-exception>
</map:action>
In pipeline:
<map:act type="mod-db-add">
<map:parameter name="table-set" value="some_table_set" />
</map:act>
In database.xml put:
<table name="foo">
<keys>
<key name="my_sub_id" type="int" autoincrement="true" primarykey="true">
<mode name="auto" type="autoincr" />
</key>
</keys>
<values>
<value name="my_id" type="int">
<mode name="request-param" parameter="my_id" type="all"/>
</value>
<value name="my_data" type="string">
<mode name="request-param" parameter="my_data_*" type="all" set="master"/>
</value>
</values>
</table>
That should work. See:
http://xml.apache.org/cocoon/userdocs/actions/database-actions.html
for more info, and http://localhost:8080/cocoon/samples/mod-db
-Tuomo
On Tue, 15 Oct 2002, Antonio Gallardo Rivera wrote:
> Hi,
>
> I am trying to insert multiple rows into a table after the user press a
> "Finish" buton.
>
> I think this can be done with modular.databse. But I dont know how to do that.
>
> Given a fixed key: my_id from a master table
> and rows:
>
> my_id
> my_subid
> my_data <--- usr input.
>
> Can someone provide a simple example?
>
> Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
