esql supports this from scratch:
<esql:execute-query>
...
<esql:use-limit-clause>mysql</esql:use-limit-clause>
<esql:skip-rows>0</esql:skip-rows>
<esql:max-rows>0</esql:max-rows>
if your database has no support for such (seem to be all others than mysql
and postgres) you can even use the jdbc way:
<esql:use-limit-clause>jdbc</esql:use-limit-clause>
<esql:skip-rows>0</esql:skip-rows>
<esql:max-rows>0</esql:max-rows>
Cheer
--
Torsten
> fantastic thanks
> ----- Original Message -----
> From: "Chris Warr" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 12, 2002 3:16 AM
> Subject: RE: Esql row-results
>
>
> > Then you want to use LIMIT, I think:
> >
> > SELECT blah from thetable LIMIT 1
> >
> > Chris.
> >
> >
> > -----Original Message-----
> > From: Sharat Koya [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, 12 April 2002 12:00
> > To: [EMAIL PROTECTED]
> > Subject: Re: Esql row-results
> >
> >
> > unfortunatly not. I am using mysql
> > ----- Original Message -----
> > From: "Chris Warr" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > 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:[EMAIL PROTECTED]]
> > > Sent: Friday, 12 April 2002 11:54
> > > To: [EMAIL PROTECTED]
> > > 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 < 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: <[EMAIL PROTECTED]>
> > > For additional commands, e-mail: <[EMAIL PROTECTED]>
> > >
> > > ---------------------------------------------------------------------
> > > 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: <[EMAIL PROTECTED]>
> > > For additional commands, e-mail: <[EMAIL PROTECTED]>
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > 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: <[EMAIL PROTECTED]>
> > For additional commands, e-mail: <[EMAIL PROTECTED]>
> >
> > ---------------------------------------------------------------------
> > 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: <[EMAIL PROTECTED]>
> > For additional commands, e-mail: <[EMAIL PROTECTED]>
> >
> >
>
>
> ---------------------------------------------------------------------
> 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: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
