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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
