Run a cfloop on the list then do a comparison against the person if it
matches then do a checked on the input type:-)
regards
Andrew Scott
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]
-----Original Message-----
From: Albert, Gregory Mitchell (Greg) [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2000 15:30
To: CF-Talk
Subject: checkboxes in a list
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/cf-talk@houseoffusion.com/
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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.