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