cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@informatik.tu-darmstadt.de>
Subject Re: xsp troubles with loops and an esql
Date Mon, 24 Nov 2003 08:12:43 GMT
gounis@osmosis.gr wrote:

>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?
>  
>

The key is to pass some more vars to the method like the object model 
and the document handler. See
generated source code for details. E.g. the esql logicsheet defines a 
method that could serve as a blue
print.

    Chris.


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


Mime
View raw message