You don't stop the data entering the database, you add a column to the db table called status.
This determines what pages are visible, which ones are pending, and possibly which ones are deleted but I would hard delete these on reject unless people want to be able to contest the rejection. The code is releatively simple and any CF book will give you examples of what to do. > -----Original Message----- > From: Ian Vaughan [mailto:[EMAIL PROTECTED] > Sent: 03 March 2003 11:02 > To: CF-Talk > Subject: Re: Is it possible to achieve workflow in Coldfusion ??? > > > Adam > > There is only one administrator or approver. > > How would you achieve this, do you have example code so I can see > how it may > function, how do you stop the data entering the database ?? > > "As part of the submit page, have it save the document away with a flag > 'pending'." > > > > > ----- Original Message ----- > From: "Adam Reynolds" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, March 03, 2003 9:46 AM > Subject: RE: Is it possible to achieve workflow in Coldfusion ??? > > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
