Return-Path: 
 <cocoon-dev-return-13477-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org
Received: (qmail 46972 invoked by uid 500); 18 May 2001 09:40:10 -0000
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-dev-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-dev-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-dev@xml.apache.org>
Reply-To: cocoon-dev@xml.apache.org
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 46956 invoked from network); 18 May 2001 09:40:07 -0000
Date: Fri, 18 May 2001 11:40:50 +0200 (CEST)
From: giacomo <giacomo@apache.org>
X-X-Sender: <giacomo@lap1.otego.com>
To: <cocoon-dev@xml.apache.org>
Subject: Re: [c2] patch for database actions
In-Reply-To: <Pine.LNX.4.33L2.0105171433240.4323-200000@localhost.localdomain>
Message-ID: <Pine.LNX.4.31.0105181140290.24522-100000@lap1.otego.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N



On Thu, 17 May 2001, Donald Ball wrote:

> attached is a patch for the database actions to allow the database add
> action to add multiple rows to multiple tables from one form of values. a
> sample form descriptor is:
>
> <map>
>   <connection>test</connection>
>   <table name="product_table">
>     <keys>
>       <key param="id" dbcol="id" type="int" mode="form"/>
>     </keys>
>     <values>
>       <value param="name" dbcol="name" type="string"/>
>     </values>
>   </table>
>   <table name="product_meta_element_table">
>     <keys>
>       <key param="id" dbcol="product_id" type="int" mode="form"/>
>       <key param="product_meta_element_name_*_param" dbcol="name" type="string" mode="form"/>
>     </keys>
>     <values>
>       <value param="product_meta_element_value_*_param" dbcol="value" type="string"/>
>     </values>
>   </table>
> </map:
>
> note that all of a table's keys must be mode="form" if you're adding many
> rows to the same table, or if the same new key value is used in multiple
> tables. i'm gonna be fixing that. anyway, it's a pretty sizable patch so i
> thought i'd flip it out for y'all to peruse before i committed it. if
> berin doesn't want this added to the main action set i'm happy to commit
> it as a new action.

As I'm not using it ATM here is my +1 for the patch.

Giacomo


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