[CFCDEV] Russian Doll design pattern

[Phillip Senn]

A few months ago, back when I thought I had a handle on this cfc thing, I posted the code to what I thought would be a model ColdFusion component. One kind reader (whose name will go unmentioned (Matt)), replied gently correcting practically every single line of code except </cfcomponent> and then whimsically stated "The rest looks ok to me!" So I'm back for more fun and merriment at my own expense, but this time with what is probably a design pattern. If I were to name it, I would call it the "Russian Doll" design pattern, after the little dolls that are inside other dolls. OK, so since I think it's better to speak in code instead of through analogies, I've created a SQL script and posted it to: http://www.aacr9.com/RussianDoll   Q: How would you put together a maintenance screen for a location table, where a location is in another location? Feel free to rename any fields to conform to the new OO way of thinking. I understand that using the word "Parent" is passé. My plan is to develop the cfm and cfc pages for this particular type of table layout.     Here's an abbreviated view: LocationID,Type,Name,ParentID  1 Country USA 0  2 Region North-East 1  3 Region South 1  4 Region MidWest 1  5 Region West 1  6 State New York 2  7 State Connecticut 2  8 State Maine 2  9 State Alabama 3  10 State Florida 3  11 State Georgia 3  12 State California 5  13 State Washington 5  14 State Oregon 5  15 City Albany 6  16 City Poughkeepsie 6  17 City Hartford 7  18 City New Haven 7  19 City Augusta 8  20 City Portland 8  21 City Montgomery 9  22 City Tuscaloosa 9  23 City Olympia 14  24 City Portland 14  25 Store myStore 24  26 Floor 1st Floor 25  27 Floor 2nd Floor 25  28 Room Dining 27  29 Room Kitchen 27   So then I would want to show in a dropdown:   Dining, 2nd Floor, myStore, Portland, Oregon, West, USA. Kitchen, 2nd Floor, myStore, Portland, Oregon, West, USA.     Running the SQL code will speak better than me explaining it. Go to http://www.aacr9.com/RussianDoll And see what I'm trying to do.   You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm CFCDev is supported by: Katapult Media, Inc. We are cool code geeks looking for fun projects to rock! www.katapultmedia.com An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org