Is it possible to have four "ancestor" like bellow? Because here I get errors for each "esql:get-string"
<esql:execute-query> <esql:query> Select * From Process_Actions Where (pa_process = <xsp-request:get-parameter name="MyID"/>) </esql:query> <esql:results> <esql:row-results> <esql:execute-query> <esql:query> select * from Actions where at_ID = <esql:get-int column="pa_atid" ancestor="1" /> </esql:query> <esql:results> <esql:row-results> <tr> <td><esql:get-string column="at_name"/></td> <td><select><xsp:attribute name="name">usrname<xsp:expr>mynum</xsp:expr></xsp:attribute> <esql:execute-query> <esql:query> select * from Users </esql:query> <esql:results> <esql:row-results> <option><esql:get-string column="ur_name"/></option> </esql:row-results> ... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]