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 ----- Original Message ----- From: Truman Esmond III 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
<<attachment: BDAsmall.jpg>>
