Return-Path: <alfredas@SSERIGA.edu.lv>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 88440 invoked from network); 20 Sep 2000 17:27:49 -0000
Received: from server.sseriga.edu.lv (194.19.242.50)
  by locus.apache.org with SMTP; 20 Sep 2000 17:27:49 -0000
Received: by server.sseriga.edu.lv with Internet Mail Service (5.5.2448.0)
	id <T23LBY73>; Wed, 20 Sep 2000 19:29:06 +0300
Message-ID: <87DD0BD4C997D311AD6300C095EC18DC0C3825@server.sseriga.edu.lv>
From: Alfredas Chmieliauskas <alfredas@SSERIGA.edu.lv>
To: cocoon-users@xml.apache.org
Subject: SQL question:  suggestions welcome...
Date: Wed, 20 Sep 2000 19:29:05 +0300
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
	charset="ISO-8859-1"
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N


Hi,

I have two SQL queries in one page, one of which has to return the general
info about the page (last edited, absolute location, author, etc)  the other
query has to form a links menu in a page according to the result of the
previous (eg. that every "author" could see his "own" menu).
<page>
.................
<query connection="mysql_connection" doc-element="page_info"
row-element="info">
	select title, context, page_author, date_edited, page_background
from page_info
</query>
<query connection="mysql_connection" doc-element="page_menu"
row-element="menu_item">
	select item_name, item_link, item_author, item_image from page_menu
where item_author=.......(how to pass the value page_author from the
previous query, if it is possible???).....
</query>
...............
</page>

alfredas