Return-Path: 
 <users-return-66560-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 95751 invoked from network); 26 Apr 2004 17:43:50 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 26 Apr 2004 17:43:50 -0000
Received: (qmail 12455 invoked by uid 500); 26 Apr 2004 17:43:31 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 12413 invoked by uid 500); 26 Apr 2004 17:43:31 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 12397 invoked from network); 26 Apr 2004 17:43:30 -0000
Received: from unknown (HELO smtp014.mail.yahoo.com) (216.136.173.58)
  by daedalus.apache.org with SMTP; 26 Apr 2004 17:43:30 -0000
Received: from unknown (HELO daddy) (mikedickson@69.29.198.66 with login)
  by smtp014.mail.yahoo.com with SMTP; 26 Apr 2004 17:43:34 -0000
From: "Mike Dickson" <mikedickson@yahoo.com>
To: <users@cocoon.apache.org>
Subject: RE: Database Insert Across Multiple Tables
Date: Mon, 26 Apr 2004 10:44:05 -0700
Message-ID: <001e01c42bb6$13867e40$6666a8c0@daddy>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Importance: Normal
In-Reply-To: <408AA790.2020909@informatik.tu-darmstadt.de>
Disposition-Notification-To: "Mike Dickson" <mikedickson@yahoo.com>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

When you hit the "new user" button in the Modular Database Actions demo
application it does a GET with the user info and the group info.  Why are
only the user data listed below as params?  Shouldn't the group data be also
listed as params?

In other words, how are the group params being passed in?

<!--

 add one new user plus groups

-->
<map:act type="req-params">
	<map:parameter name="parameters" value="add-user-groups user.name
user.firstname user.uname"/>
	<map:act type="mod-db-add">
		<map:parameter name="table-set" value="user+groups"/>
	</map:act>
</map:act>

> -----Original Message-----
> From: Christian Haul [mailto:haul@informatik.tu-darmstadt.de]
> Sent: Saturday, April 24, 2004 10:45 AM
> To: users@cocoon.apache.org
> Subject: Re: Database Insert Across Multiple Tables
>
>
> Mike Dickson wrote:
> > We are using Cocoon 2.1/MySQL 4.0.16 and have user data
> from a HTML form
> > that needs to be inserted into two tables inside a single
> transaction.
> > Inserts into a single table seem to be simple, but into
> multiple tables is
> > little harder...
> >
> > How should I accomplish this?
> >
> > I have looked at <table-set> in the new Cocoon 2.1 Database
> Actions, but am
> > stumped as to how to use them from the docs.  Sorry
> Reinhard Horn!  :-)
>
> Could you elaborate a little more on were you're stuck?
> Essentially, you
> just list multiple tables in a table set and ask the action to use it.
> The sample that comes with Cocoon does it BTW.
>
> 	Chris.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org