On 20.Feb.2002 -- 03:49 PM, marco wrote:
> I have a user input form and which is used to add/update/delete records in
> serveral tables. I found a sample that came with cocoon, but it is simple
> example that only one table is handled at a time.
>
> How can I make use the default DatabaseAddAction, DatabaseUpdateAction,
> DatabaseDeleteAction to manipulate the data of mutiple tables at a time.
Easy: just add another table to the descriptor file. The action will
attempt to insert data in all tables listed. Of cause, if it's not
feeded enough data it will rollback the complete transaction.
You may not use autoincrement columns with the default database
actions if you need the column's value lateron. You may use the manual
mode for autoincrement columns but that could have concurrency issues
depending on your database setup.
In scratchpad you'll find actions that don't have these
limitations. While the descriptor file syntax will not change (being
different from descriptor file for main trunk db actions!), the
actions (including their name and how to employ the helpers) will
change shortly.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
