Return-Path: <balld@webslingerZ.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 70293 invoked from network); 19 Sep 2000 01:49:29 -0000
Received: from rdu25-20-164.nc.rr.com (HELO ma7.webslingerZ.com)
 (@24.25.20.164)
  by locus.apache.org with SMTP; 19 Sep 2000 01:49:29 -0000
Received: by ma7.webslingerZ.com (Postfix, from userid 501)
	id E7CDC4810; Mon, 18 Sep 2000 21:51:50 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by ma7.webslingerZ.com (Postfix) with ESMTP id E536A6087
	for <cocoon-users@xml.apache.org>; Mon, 18 Sep 2000 21:51:50 -0400 (EDT)
Date: Mon, 18 Sep 2000 21:51:50 -0400 (EDT)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: balld@localhost.localdomain
To: Cocoon User <cocoon-users@xml.apache.org>
Subject: Re: SQL Processor and many SQL request
In-Reply-To: <39C63449.EB66164C@cti-paysloire.cnamts.fr>
Message-ID: <Pine.LNX.4.21.0009182151230.2272-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

On Mon, 18 Sep 2000, LEBRETON Philippe wrote:

> How i can update many in my DATABASE with the SQL Processor ?
> 
> I use the SQL Processor, and in my XML i want make :
> <query connection="Maj">
> update EtatBase set commentaire="Bonjour" where Id='1'
> update EtatBase set commentaire="Bonsoir" where Id='2'
> update EtatBase set commentaire="Hello" where Id='3'
> </query>
> 
> It-doesn't work.
> Why ?

because. use the sql or esql logicsheets, or else just put in more than
one query element.

- donald