Return-Path: 
 <users-return-91354-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 6813 invoked from network); 2 May 2007 14:36:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 2 May 2007 14:36:18 -0000
Received: (qmail 39527 invoked by uid 500); 2 May 2007 14:36:20 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 39466 invoked by uid 500); 2 May 2007 14:36:20 -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
List-Id: <users.cocoon.apache.org>
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 39454 invoked by uid 99); 2 May 2007 14:36:20 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 May 2007 07:36:19 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=NO_REAL_NAME,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of ypomonh@freemail.gr designates
 81.171.104.45 as permitted sender)
Received: from [81.171.104.45] (HELO www.freemail.gr) (81.171.104.45)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 May 2007 07:36:12 -0700
Received: from www.freemail.gr (www.freemail.gr [127.0.0.1])
	by www.freemail.gr (8.12.11.20060308/8.12.11) with SMTP id l42EZoiC019197;
	Wed, 2 May 2007 17:35:50 +0300
Reply-To: ypomonh@freemail.gr
From: ypomonh@freemail.gr
To: users@cocoon.apache.org
Subject: Re:  Re: (newbiew) Determine program flow
Date: Wed, 2 May 2007 17:35:50 +0300
Message-Id: <4638a1c64c0cf0.88250188@freemail.gr>
References: <46388F70.6040102@apache.org>
X-Authenticated-IP: dhcp72.test.noc.ntua.gr (147.102.247.72)
X-Sender: ypomonh@81.171.104.54
X-Mailer: FreeMail.gr 1.08 (http://www.freemail.gr/)
X-Info-1: Report spam to abuse@freemail.gr
MIME-version: 1.0
Content-type: text/plain; charset="iso-8859-7"
X-Virus-Checked: Checked by ClamAV on apache.org


> ypomonh@freemail.gr napisa�&#65533;(a):
> > I need to determine the program flow depending on the result of a DB query: if the query returns zero reselts execute this pipeline or else execute that pipeline.
> >
> > It might trivial but I can't find an example anywhere :(
> 
> The best way is to use flowscript. How do you query your DB?

Through the SQL transformer:


###### map ######
<map:pipeline>
	<map:match pattern="checkParameters">
  <map:generate src="sql/checkParameters.xml"/>
	<map:transform type="sql">
	<map:parameter name="rid" value="{request-param:rid}"/>
	</map:transform>
	<map:serialize type="xml"/>
	</map:match>
</map:pipeline>

###### query ######
<document xmlns:sql="http://apache.org/cocoon/SQL/2.0">
 <sql:execute-query>
  <sql:use-connection>datamed</sql:use-connection>
  <sql:query>
  SELECT * FROM report_parameter_map WHERE  report_id = '<sql:substitute-value name="rid"/>'
  </sql:query>
</sql:execute-query>
</document>


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