Actually the admin would open it back up to the original user to edit/make changes. So the admin would say John Smith can change quarter 2. When John Smith is done with the changes and the admin checked them then their permission is turned back off. I guess what I was thinking is have another field in user that if null/0 go to regular page. if 1 edit first quarter if 2 edit 2nd quarter.... so the admin picks the user and the quarter that needs changed. In theory if a person is in quarter3 they shouldn't have to edit quarter 1- but they want the flexibility.
-----Original Message----- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 4:18 PM To: CF-Talk Subject: Re: Changing access > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
