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
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
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
Ian,
Perhaps I can clarify/expand on what Adam suggested:
1) You do not stop the data entering the database when a story is
submitted. Instead, it is inserted as normal but you also set another
column probably in the same table, perhaps named status with a value
of P for pending when you perform
Andre
Thanks for the explanation!!
Ok I understand how it is working -
A user fills in the fields and clicks submit the data in entered into the db
with a 'status' field set to a default of 'Pending'
Ok
Then when the form is submitted I use CFMail to send an e-mail to the
approver informing
Ian,
I see no flaws the logic you outlined; seems perfectly acceptable to me.
As for adding more features and or more advanced settings, that is
entirely dependent on whether they are justified, required or are likely
to be required - something which only you are in a position to judge at
You might want to think about whether there is a required publication date.
For example, if a story is entered, but is embargoed until next week, you
might want to store that publication date and it won't show up on the site
until that date arrives.
H.
-Original Message-
From: Ian
7 matches
Mail list logo
