You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cocoon.apache.org by go...@osmosis.gr on 2004/03/15 19:37:17 UTC

esql select max() | how to get result

hi people

i try to run this sql query

            <esql:execute-query>
                <esql:query>SELECT max(id_Elements) AS id_Elements FROM  tblElements</esql:query>
                <esql:results>
                    
                </esql:results>
                <esql:no-results>
                no record was found
                </esql:no-results>
            </esql:execute-query>

but i dont know hot to get the resutl in <esql:results> ... </esql:results>

any hint 

i have try 
<esql:row-results>
<esql:get-columns/>
</esql:row-results>

but without success


thanx


--stavros 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org