thats what i was trying to say, thanks andrew. emmet... do this...
simply add a parentID column to your table, and whatever value that is, you can find its parent, or no parent. tw On 6/2/05, Andrew Scott <[EMAIL PROTECTED]> wrote: > Without more information this request is not possible. > > Is this coming from a database then use the original query to build a parent > child relationship, without and identifier which indicates what the parent > is then you can do what your asking. > > > -----Original Message----- > From: Emmet McGovern [mailto:[EMAIL PROTECTED] > Sent: Friday, 3 June 2005 12:09 AM > To: CF-Talk > Subject: get parent items from list? > > Brain Meltdown. Maybe someone can help. > > I have a list such as (item1,item2,item3,item4,item5). The list can be any > length. Item1 would be the parent of item2 and item2 would be the parent of > item3 and so on. > > What's the most efficient way of determining the parent of any item in the > list and determining that item1 has no parent? > > Thanks, > Emmet > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
