Ian, This is relatively simple. As part of the submit page, have it save the document away with a flag 'pending'.
Is there just one administrator? Do you want different admin for different areas of the site? That is the real pain. You could have a pending approval page that admin can go to to see any pending pages. They could then view (AND edit) those pages before accepting the content or rejecting the comment. Adam > -----Original Message----- > From: Ian Vaughan [mailto:[EMAIL PROTECTED] > Sent: 03 March 2003 09:38 > To: CF-Talk > Subject: Is it possible to achieve workflow in Coldfusion ??? > > > Hi > > I am trying to add a workflow element into a news application, and would > just like to hear if anybody else on the list have been able to achieve > this? or best practices on how to achieve this? > > I have an admin form that allows users to add news stories. At > present when > the form is submitted the data is entered into the database table. > > What I would like to achieve is when the user submits the form an > e-mail is > sent to the relevant approver. They view their e-mail and click > on the link > which opens up their admin screen. > > >From here they can see they have content to approve. The approver reads > through the story and if they are happy they approve the data and it is > entered into the database and goes live on the site. > > If the approver declines the story it sends the user who created > the content > an e-mail with why the data was not approved and the changes needed to be > made, and the story does not go live on the site. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

