Return-Path: 
 <cocoon-users-return-33048-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 58487 invoked by uid 500); 6 May 2002 06:44:29 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 58476 invoked from network); 6 May 2002 06:44:28 -0000
Message-Id: <scd64274.030@bdal.de>
X-Mailer: Novell GroupWise 5.5.2
Date: Mon, 06 May 2002 08:44:27 +0200
From: "Malte Vahlenkamp" <Malte.Vahlenkamp@bdal.de>
To: <cocoon-users@xml.apache.org>
Subject: Modular Database Actions - Multiple Inserts
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hello,

I have some problems with the modular database actions. I am trying to =
insert multiple rows from a form with several text boxes named ProjectParam=
1, ProjctParam2, ... The insert itself is runs, but all I get in this =
columns is a NULL value.  I already tried to solve this with a wildcard =
[*] but maybe I messed up something with the syntax. Any comments?

Thanks for your time

  Malte


Heres is the mapping I defined for the database action:

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D SNIP =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=09
	<table name=3D"projectparams" alias=3D"projectparams">
		<keys>
			<key name=3D"ProjectParamsId" autoincrement=3D"true=
" type=3D"int">
				<mode name=3D"auto" type=3D"autoincr"/>
			</key>	=09
		</keys>
	=09
		<values>
		<value name=3D"ProjectId"  type=3D"int" set=3D"master">		=
						=09
			<mode name=3D"attribute" parameter=3D"org.apache.co=
coon.components.modules.output.OutputModule:projects.projectid[0]" =
type=3D"attrib"/>		=09
		</value>
	=09
		<value name=3D"ParamName"  type=3D"int">			=
					=09
			<mode name=3D"request" parameter=3D"ParamName[*]" =
type=3D"all"/>		=09
		</value>
	=09
		<value name=3D"UnitName"  type=3D"int">				=
				=09
			<mode name=3D"request" parameter=3D"UnitName[*]" =
type=3D"all"/>		=09
		</value>
		</values>
	=09
	</table>
	=09
	<table-set name=3D"userAndProjects">
		<table name=3D"projects"/>
		<table name=3D"userprojects" others-mode=3D"attrib"/>
		<table name=3D"projectparams" others-mode=3D"attrib"/>
	</table-set>

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D SNIP =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

And these are the request parameters

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D SNIP =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

<attributes>
<xsp-request:attribute-names>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
userprojects.UserId[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
projectparams.ProjectParamsId[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
projectparams.ProjectId[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
projects.projectid[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
projects.userid[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
projects.ProjectName[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.components.modules.output.OutputModule:=
userprojects.ProjectId[0]</xsp-request:name>
<xsp-request:name>org.apache.cocoon.action.modular.DatabaseAction.outputMod=
eName</xsp-request:name>
</xsp-request:attribute-names>
=09
</attributes>
=09
<parameters>
<xsp-request:parameter-names>
<xsp-request:name>ProjectName</xsp-request:name>
<xsp-request:name>ProjectParamsId1</xsp-request:name>
<xsp-request:name>ProjectId</xsp-request:name>
<xsp-request:name>UserId</xsp-request:name>
<xsp-request:name>UnitName1</xsp-request:name>
<xsp-request:name>ParamName1</xsp-request:name>
</xsp-request:parameter-names>
=09
</parameters>=09

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D SNIP =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>