cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Warr <Chr...@esd.nec.com.au>
Subject RE: Esql row-results
Date Fri, 12 Apr 2002 02:16:45 GMT
Then you want to use LIMIT, I think:

SELECT blah from thetable LIMIT 1

Chris.


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


unfortunatly not. I am using mysql
----- Original Message -----
From: "Chris Warr" <ChrisW@esd.nec.com.au>
To: <cocoon-users@xml.apache.org>
Sent: Friday, April 12, 2002 3:02 AM
Subject: RE: Esql row-results


> 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>
>
>


---------------------------------------------------------------------
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>


Mime
View raw message