flipandboef
Posts: 107
|
| Posted: 02/22/2010, 10:57 AM |
|
---- EDIT----
I made this post simpler in the hope to get some assitance with this, leaving my original post below...
I have a drop-down list, coming out of a table "X".
Example values 1,2,3,4 and 5
Also have 3 security levels: 1, 10, 100
What I try to do, is to show the values from table X with a security check on it, using the GroupID.
Example:
Show values 1,2 and 3 when security level = 1
Show 1,2,3 and 4 when security level = 10
Show 1,2,3,4 and 5 when sec. level = 100
I know how to do a "where" statement in CCS but not sure how to use that with the security / GroupID involved.
Any suggestions?
Using CCS 3.2 + MS-Access + ASP
---- Original post ----
I purchased the vcalendar CCS project files from Ultraapps, but am wondering if I can make it where specific (admin) users can add/edit selective categories in the public events, while keeping all categories available for private events.
Example:
User 1 can add/edit/delete categories A and C in the public events
User 2 can add/edit/delete categories A and D in the public events
User 3 can only add/edit/delete category B in the public events
All users can view all categories in the public events and can add/edit/delete their private events.
(They're both shown on the same calendar, have a look at VCalendar from UltraApps at http://www.ultraapps.com/app_overview.php?app_id=19)
The MS-Access DB has 3 security groups:
1 - viewer
10 - user
100 - admin
Values for the dropdown box fir the categories, come straight out of the database (in viewing AND add/editing).
Example:
- Birthdays
- Meetings
- Vacation
- etc....
So 'in theory' I was thinking:
Filter out the values a user should not have access to from the drop-down box, showing only the ones access is allowed (based on user_id?)
Then I got stuck thinking, this will prevent users from adding their private events with those categories...
So doubt if that's the way to go.
Unless.....
To make an event 'public', a checkbox has to be check-marked. With Javascript, I could check this box if it's checked for 'public' and reflect the right values (once they're filter by user access) or show them all when the box is unchecked.
Does anyone have experience with VCalendar (or just has the knowledge) and has done something similar?
Am I as not a guru ASP coder, in over my head with this one?
At this point I don't even have a clue on how to solve this puzzle, so any suggestions, etc are very much appreciated  ...
Using CCS 3.2 + MS-Access + ASP
|
 |
 |
Oper
Posts: 1195
|
| Posted: 03/10/2010, 10:24 AM |
|
ok Let suppose your table X has the level somewhere in the Table
TABLE X:
1,5
2,5
3,5
4,10
5,100
in the Listbox BUILDER
use
X.SecurityFieldName <= ccgetgroupid() (expresion)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
