esql select max() | how to get result

[gounis]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]