Function using same function

[joerivl]

Hi

I would like to make a function that can refer to itself if a certain action
occurs.
In this case, a function that loops through a table, gets the ID and performs
the same function to get the children

output must be like this

home
categ. A
categ. A1
categ A1.1
categ. A2
categ. B
categ B1

My attached code shows only the first line.
what I'm I doing wrong?
any suggestions are welcome...

Tnx

Table categories:

[ page_id | page_title | parentid ]
| 1 | home | 0 |
| 2 | categ. A | 0 |
| 3 | categ. B | 0 |
| 4 | categ. A1 | 2 |
| 5 | categ. A2 | 2 |
| 6 | categ. B1 | 3 |
| 7 | categ. A1.1| 4 |


<cfscript>
function DisplayCategories(parentid) {
SQLString = "SELECT page_id, page_title FROM categories WHERE parentid=" &
parentid;
DATASOURCE = "website_one";
getcategories=getquery(SQLString: SQLString, DATASOURCE: DATASOURCE);
if (getcategories.RecordCount GT 0)
{
for(currRow=1; currRow LTE getcategories.RecordCount; currRow=currRow+1)
{
WriteOutput(sublevelmarker&getcategories.page_id[CurrRow]&':');
WriteOutput(sublevelmarker&getcategories.page_titl e[CurrRow]&'<br>');
DisplayCategories(getcategories.page_id[CurrRow]);
};
};
};
DisplayCategories(0);
</cfscript>

[Adam Cameron]

When writing functions, you generally want to declare all variables as
local, especially when writing recusrive code such as you are.

<cfset var foo = "bar">

--

Adam

[DaveF67]

in a component have two functions:

<CFFunction name="doLoop" output=yes>

[joerivl]

I have seperated the query as suggested and everything seems to work now...
Thanks!