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 &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: <[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]>

Reply via email to