"Archived" in a CMS often means removing the content from a "live" table or tables and moving it to an "archive" table or tables, which is necessary for keeping the database fit and trim (and performant). This is typically combined with a checkbox on a search form to "Search Archives As Well," which in turn changes the database view that is searched (one view for live content only -- the default -- and another view that UNIONs the live and archived tables).
What you're doing sounds like partitioning within the same table, which you can do by simply adding an Archived bit column to the PlumContentItem table, adding a corresponding field to the forms that manage the content, and making the other changes to the search functionality in Verity.cfc to separate your content into two physical collections for each virtual collection (live and archived). Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "David Jones" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, May 27, 2005 10:02 AM Subject: [plum] CMS Question > I seem to be in an "archive" mood this week. I don't have experience with a > wide variety of CMS tools, but is a status of "Archived" (in addition to > Inactive/Rejected/Created/Published) a common thing? This is definitely not > a high priority feature request - I'm just curious (it's relatively easy to > do on the front-end in a myriad number of ways). I'm working on a few > projects where I'll be displaying current "articles" using > <cf_DisplayContentNamesByCategory>, but I'd like to keep all of the related > items in the same category and segregate them by current and archived. This > may be an overly simplistic view of how to do this, but I'm definitely open > to suggestions. > > > > Thanks, > > > > Dave Jones. > > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
