Re: recursion in cold fusion ( was RE: Creating a list with infinite groupings and indents )

2003-07-09 Thread Paul Hastings
> First and foremost, we can't run queries inside of tags. Bummer. easy enough with a wrapper function. > Second, even if the query issue were resolved (and if you've got ideas for > work-arounds, I'd love to hear them), you've now got variable scope issues. > A variable declared in a CFMX page

Re: recursion in cold fusion ( was RE: Creating a list with infinite groupings and indents )

2003-07-09 Thread Sean A Corfield
On Wednesday, Jul 9, 2003, at 13:13 US/Pacific, Hagan, Ryan Mr (Contractor ACI) wrote: > function list_categories( $parentId, $level ) { > global $database, $connection; > $numSpaces = 5; > $query = "SELECT * FROM myTab

RE: recursion in cold fusion ( was RE: Creating a list with infinite groupings and indents )

2003-07-09 Thread Barney Boisvert
56.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Paul Hastings [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 1:33 PM > To: CF-Talk > Subject: Re: recursion in cold fusion ( was RE: Creating a list with > infinite grouping

Re: recursion in cold fusion ( was RE: Creating a list with infinite groupings and indents )

2003-07-09 Thread Jochem van Dieten
Hagan, Ryan Mr (Contractor ACI) wrote: > > I personally like this solution quite a bit. I know it has performance > issues, but I've never noticed any significant impact on server response, > even under heavy load. I think it is an ugly workaround. SQL is a set oriented language and the best wa