> I have an application where users edit information each quarter. Once
the
> end of quarter date is reached they can no longer enter any data- it
becomes
> view only.
> On occassion these users need to go in and fix errors in the past
> quarter(s). I need a way for the admin to open it up for them to edit
their
> material. I'm not sure on the best way to structure all of this most
> efficiently.
It doesn't seem like you need the full users/groups/permissions
system - you just want one or two administrators to have full
access to edit all records, regardless of date, yeah?
I guess I would stick a boolean field in the users table, and flag
the users designated as admins. Then when a page is output,
do something like:
<cfif [date between beginning and end of quarter] OR
userInfo.administrator>
[input form]
<cfelse>
[just output]
</cfif>
where userInfo.administrator reference the boolean field in
the table (from a CFQUERY or maybe you store the info in
the Session scope...).
> And then on the display page how do I
> make it so that only the selected quarter shows up?
I think this would be down to filtering the CFQUERY, sticking
a WHERE statement or 2 into the SQL to only grab records
between certain dates.
HTH,
- Gyrus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
