Jian, Go have a look at the Nest Tree Model @ http://www.codebits.com
This is what you are talking about. ;o) Regards Stephen ----- Original Message ----- From: "jian xu" <[EMAIL PROTECTED]> To: "CF-Server" <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 4:22 PM Subject: How to run the query > hi, I have a table Application with the following structure: > > applicationID int(4) (Primarykey) > title, varchar(5200) > abstract, varchar(100) > linkurl, varchar(100) > parentID, int(4) > addDate, datetime > modifiedDate, datetime > > The basic idea is that an application may have children, which may also > have children and so on. If a record has a parent, I will store the > applicationID of the parent record in the parentID field of the current > record. This may have three or four level and even more. I can > successfully insert data into > the table, however I don't how to query the data and display in three or > four levels in a table format. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
