cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@dff.st>
Subject Re: Esql row-results
Date Fri, 12 Apr 2002 07:35:50 GMT

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" <ChrisW@esd.nec.com.au>
> To: <cocoon-users@xml.apache.org>
> 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: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>
> >
> >
>
>
> ---------------------------------------------------------------------
> 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