Thanks a lot. I was able to insert records to more than one table at a time, but according to the documentaion of the actions "DatabaseUpdateAction" and "DatabaseDeleteAction" that they can handle only one table at a time. Please advise.
----- Original Message ----- From: "Christian Haul" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 2:30 AM Subject: Re: howto make use of default database add, delete, update action for mutilple table at a time > 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]> > > --------------------------------------------------------------------- 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]>
