Re: esql select max() | how to get result

[Christopher Painter-Wakefield]

either of these should work:
<esql:row-results>
      <esql:get-string column="1"/>
</esql:row-results>

<esql:row-results>
      <esql:get-string column="id_elements"/>
</esql:row-results>



|---------+---------------------------->
|         |           [EMAIL PROTECTED]|
|         |                            |
|         |           03/15/2004 01:37 |
|         |           PM               |
|         |           Please respond to|
|         |           users            |
|         |                            |
|---------+---------------------------->
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                                    
                          |
  |       To:       [EMAIL PROTECTED]                                                  
                    |
  |       cc:                                                                          
                          |
  |       Subject:  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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]