RE: DHTML recursion problem

[Micha Schopman]

Just a word of advice, place the entire business logic of recursion in a
stored procedure. What you do know, is make numerous calls to the
database server, which is by far, more slower and cpu intensive than
putting the job at SQL Server.

 
tSQL gives you enough functions and possibilities to get recursive
functions.

 
This means, you only call the database once, and then you get a nice
result set back ready to use.

Micha Schopman
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: DHTML recursion problem

[Metzy Martinez]

It's extremely fustrating. I'm trying to convert JAVA code into coldFusion and i tried to go with CFTREE but there is a problem with it ColdFusion 5 server. I tried to implement the recursive tree function found in the o'reilly ColdFusion 5 book. that of course is using CFtree.
ughhh.

thanks for your help :)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: DHTML recursion problem

[stylo stylo]

I don't know, but it's a nasty way to do it. 

First of all, you don't need to call every function in the onclick (lowercase, not camelCase). Just send the needed var to a function and go from there.

Secondly, you should not even have cf put onclick inline; just have a class on the nec. menu items, then use js to add the onclick via a getElementsByClassName script. The images can also be background images associated with a class.

See here for some ideas:
http://www.kryogenix.org/code/browser/aqlists/

I understand, however, if you are stuck with a script that's not yours :-(
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]