I am designing an administration area and I need to assign a single page to
multiple people. Because I don't know how many people will need access and
because I'll be adding/deleting people all the time, I need to make all of
the values go into the same field (userPermissions) in the database.
The "pages" table has the following fields: pageID, pageDescription,
userPrivileges.
My code looks something like this:
<cfoutput>
<input type="checkbox" name="userPrivileges" value="#userID#">#userID#
</cfoutput>
I can submit these values without a problem. A comma-delimited list is
inserted into the DB.
My problem is that when I try to edit the page to change permissions, I
can't see who was selected (or checked) before and who wasn't.
I know this is a common problem, but I haven't been able to find any
articles that really explain the problem I'm running into. I know it's
something simple that I'm just not seeing.
Can anyone shed some light on my problem? Thanks in advance!
Greg Albert
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
