cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sharat Koya <sxk...@Cs.Nott.AC.UK>
Subject Esql row-results
Date Fri, 12 Apr 2002 01:53:33 GMT
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>
  <action><get-string column="action"/></action>
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. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message