Hey Doug, Doug again here...I implemented the database that you and others were speaking of. Everything seems to be in order with the exception of one thing. I am populating a menu with the categories from the table and when there is no more records as I drill down, the menu will simply dissapear. This problem did not present itself in the old design due to the fact I was using 2 tables and joing them. I suppose there was always records there that way. Any suggestions to stop the menu from vanishing when there is no records to build it with?
Thanks Doug ----- Original Message ----- From: "Doug Boude (rhymes with 'loud')" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, August 21, 2006 3:33 PM Subject: Re: Database design question > > > > > > > >----- Original Message ----- > >From: "Michael E. Carluen" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[email protected]> > >Sent: Monday, August 21, 2006 12:53 PM > >Subject: RE: Database design question > > > > > >> Doug, yYou can actually use a single table for that. One way is to > >create > >a > >relationships > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
