Return-Path: <edwin@pannenleiter.de>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 80288 invoked from network); 14 Mar 2000 20:59:06 -0000
Received: from moutvdom00.kundenserver.de (195.20.224.149)
  by locus.apache.org with SMTP; 14 Mar 2000 20:59:06 -0000
Received: from [195.20.224.204] (helo=mrvdom00.schlund.de)
	by moutvdom00.kundenserver.de with esmtp (Exim 2.12 #2)
	id 12UyPB-0003n8-00
	for cocoon-users@xml.apache.org; Tue, 14 Mar 2000 21:59:05 +0100
Received: from u-184.nurnberg.ipdial.viaginterkom.de ([62.180.8.184]
 helo=wonko)
	by mrvdom00.schlund.de with smtp (Exim 2.12 #2)
	id 12UyP5-00054o-00
	for cocoon-users@xml.apache.org; Tue, 14 Mar 2000 21:58:59 +0100
From: Edwin Glaser <edwin@pannenleiter.de>
To: cocoon-users@xml.apache.org
Subject: Re: 2 SQL queries
Date: Tue, 14 Mar 2000 21:56:42 +0100
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
MIME-Version: 1.0
Message-Id: <00031422011302.05324@wonko>
Content-Transfer-Encoding: 8bit
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

Hello,
 
Simon Dueckert wrote:
> I have a problem processing 2 SQL queries in a row. My problem is that I 
> need to do a query and than take the result from this first query and 
> form another query out of it to perform a second query. 

> Any solutions? 

Yes, and I hope the cocoon community will not kill me.

Keep it simple and stupid, write the logic-sheet in XSL! The rmdms project
(rmdms.sourceforge.net) tries to translate this concept into action.

Your logic-style-sheet may include something like:

<xsl:template name="fetch-list">
  <pl:variable name="list" document="$document">
    select name, id from from articles
  </pl:variable>
  <xsl:apply-templates select="$list" mode="fetch-details"/>
</xsl:template>

<xsl:template match="articles/item" mode="fetch-details">
  <xsl:choose>
    <xsl:when test="@name='foo'">
      <xsl:call-templates name="emit-foo"/>
    </xsl:when>
    <xsl:otherwise>
      <pl:variable name="parts" document="$document">
        select name from from parts where id = <xsl:value-of select="@id"/>
      </pl:variable>
      <xsl:apply-templates select="$parts" mode="emit-part"/>
    </xsl:otherwise>
   </xsl:choose>
</xsl:template>

Rmdms is not usable yet. Database mapping is very rudimentary,
Xalan bindings are not finished and the demos don't separate
application logic and rendering. But it started just one month ago.

Regards, edwin

-- 
Edwin Glaser -- edwin@pannenleiter.de