Return-Path: 
 <cocoon-users-return-31754-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 37580 invoked by uid 500); 12 Apr 2002 01:57:27 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 37569 invoked from network); 12 Apr 2002 01:57:26 -0000
Message-ID: <E6F2CFA041D9D21190540000F801D224B396BB@esdmfs.esd.nec.com.au>
From: Chris Warr <ChrisW@esd.nec.com.au>
To: cocoon-users@xml.apache.org
Subject: RE: Esql row-results
Date: Fri, 12 Apr 2002 12:02:19 +1000
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

does 'select top 1 ....' do what you want.  It just returns one row of the
query results.  Not sure if all dbs support it though.  Very handy though.

Chris.

-----Original Message-----
From: Sharat Koya [mailto:sxk99c@Cs.Nott.AC.UK]
Sent: Friday, 12 April 2002 11:54
To: cocoon-users@xml.apache.org
Subject: Esql row-results


Hi, I have searched through the archives over the past hour and haven't
found anything for this problem.

What I want to do is execute a esql query that returns the results from a
table but only selects the first row. eg..
normal esql namespace excluded...

<query>select * from action where due &lt; current_timestamp</query>
<results>
 <row-results>
  <action><get-string column="action"/></action>
 </row-results>
</results>
what i want to be able to do is return only one action and ideally the first
one it comes across. Once it does i can then set about processing the action
and then delete from the database.

any ideas?

thanks for any time put in

Sharat Koya


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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