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
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
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
> 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
This brings up an interesting question for me. I tend to use recursive
functions frequently, and have even had to solve a problem very similar to
the original question posed in this thread. My take on the solution is the
following (in php):
itemIDitemparentID
---
5 matches
Mail list logo
