[cfaussie] Re: Having a bad day with this problem

[Andrew Bateman]

I would suggest using the Nested Set model instead of storing references to the 
parent object in the table. 
 
This will avoid recursive loops and is very efficient for retrieving data 
[though not so efficient for inserts and updates].  
 
See http://coldfusion.sys-con.com/read/42123.htm
 
Andrew
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---