> If you are looking to do a data recursion... you could glean from some > speedy data tree concepts like this also... if not... it will > help you with > data recursion when you get there. > > http://www.sitepoint.com/article/1105/2/session
I've just got to say I'm a huge fan of the method described in this article. If you have to store recursive structures in a DB its the way to go. Its a bit tricky getting your head around it if you're used to the Id/parentId method, but once you get it set up your SELECT's will be much, much faster and your UPDATES/INSERTS will only be slightly more painful. Cheers Mark ------------------ Mark Stanton Technical Director Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.com ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
