Changing the format of the database is not an option.
Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Bateman Sent: Monday, 8 October 2007 9:57 AM To: '[email protected]' Subject: [cfaussie] Re: Having a bad day with this problem 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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
