RE: Using recursion with query results

If you're tree-ing the recordset, I assume that you have a itemID/parentID field coupling?Here's the basic algorithm that I use to perform such a convertion: cffunction name=makeTree cfargument name=rs / cfargument name=parentID default= / cfargument name=level default=0 / cfloop query=rs cfif

RE: Using recursion with query results

I think your friend may be the array notion for a ColdFusion record set.Try playing with these and see if this doesn't lead somewhere. The following forms are perfectly legal ways to reference record sets. query.columnName[row] query[columnName][row] Also if you are using a cfoutput