It's great to hear from you Adam. I hope you and your family had a wonderful holiday season.
Listen, I think we are ready to let you and David back in the club, and are willing to wave the initiation fee just this once. ;) Seriously, good to hear from you. Say hi to David. Jeff On 1/23/07, Adam Churvis <[EMAIL PROTECTED]> wrote:
We created a rather elaborate CMS in our pre-Plum days, and it still runs a large aerospace news site to this day. The versioning mechanism was built using a trigger on the content table that created versions in a separate content revision table. That way the currently published content stayed published as originally approved, and could be compared side-by-side at the editor's leisure and either approved or rejected with nary a bump in the workflow. It also maintained a full editing history. In your trigger, make sure you don't start saving revisions until the status of the original content is set to at least "Submitted For Approval" (or whatever similar status your workflow may use) so you don't spawn hundreds of unnecessary "revisions" that aren't even complete yet. You may want to similarly block other statuses from revisions (like "Needs Revision," which the editor would set the status back to if necessary). Just make sure you remember that SQL Server triggers are set-based, not row-based, per triggering event, so you're going to have to use relational inserts and updates based on the entire set, even if your set only includes a single row. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in *C# & ASP.NET 2.0 for ColdFusion Developers* at ProductivityEnhancement.com <http://www.ProductivityEnhancement.com> ----- Original Message ----- *From:* Truman Esmond III <[EMAIL PROTECTED]> *To:* [email protected] *Sent:* Tuesday, January 23, 2007 3:06 PM *Subject:* [plum] "draft mode" CMS enhancement avail? & possible contract oppy... Hello fellow PLUMers! We're looking to expand the current built-in CMS with simple "draft" mode functionality to support a basic review/approval process, without pulling the previously-published content from the live app. First question is, has anyone done this yet? Second, we've got a few projects in the queue (including this one) and are wondering if anyone on this list (decent CFer w/at least some PLUM experience is assumed) is looking for some hours in the next few weeks? Thanks and, if you want to talk about working together, please email me off list. Hope no one minds me making this little solicitation here. Best, Truman [EMAIL PROTECTED] President/CEO *Breckenridge Communications Inc.* 3455 Ringsby Court #103 Denver, CO 80216 *p* 303.534.2924 *f* 303.534-2925 *c* 303-378-5484 *w* http://www.breckcomm.com *Develop Your Sense of Site*
-- v/r, Jeff Fleitz
<<attachment: BDAsmall.jpg>>
