hi people
last days i'm in trouble trying to run a "recursive" - like SQL query
in my table are rows with an id column and a column that specify the
parent_id (row). so when i get a row (with id=10 for example) the i have
to ask all the rows with the value 10 in column patent_id (but for each
row and before get the next row-results i have to run a SQL query that
search for all rows that are have parent_id = this row id) and so on....
i have a succesfull output using an .xsp with hand coded nested esql
queries (3 or 4 levels)
the problem is tha i dont know how many levels i have to go.
trying to put this esql query into a function who will call it-self has
began my odysey.
i need something like
<xsp:logic>
public void getChilds(String parent_id){
<esql:execute-query>
<esql:query>select * from tblElements WHERE
element_Parent= <xsp:expr>parent_id</xsp:expr></esql:query>
<esql:results>
<xsp:logic>parent_id = <esql:get-string
column="element_id"/>;</xsp:logic>
<esql:get-columns/>
call getChilds(parent_id);
</esql:results>
</esql:execute-query>
}
getChilds("1");
</xsp:logic>
what i try to do is to display all elements from the table in a Tree-like view
<element>
<id>5</id>
<parent_id>1</parent_id>
<element>
<id>6</id>
<parent_id>5</parent_id>
</element>
<element>
<id>9</id>
<parent_id>5</parent_id>
<element>
<id>12</id>
<parent_id>9</parent_id>
</element>
</element>
</element>
any idea?
thnx for your replies
--stavros
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
