Checkboxes and CF

Emmim,

Dan was correct in saying that you are doing it the hard way.  Checkboxes mean that there is a natural grouping.  If you want bit values represented whether 1 or 0, I would suggest putting this together on the ColdFusion side.  I would do this by looping through the code like this on the front end:

<cfloop query="recordset">

     <input type='checkbox' name='Admin' value=''#recordset.field#">

</cfloop>

This would create:

     <input type='checkbox' name='Admin' value="1">

     <input type='checkbox' name='Admin' value="2">

     <input type='checkbox' name='Admin' value="3">

     <input type='checkbox' name='Admin' value="4">

on the action page do the following:

<cfset Variables.myNewList = "_">

<cfif isDefined("form.Admin")>

<cfloop query="recordset">

     <cfif Listfind(form.admin,recordset.fieldname)>

           <cfset Variables.myNewList = Variables.myNewList & "1">

     <cfelse>

          <cfset Variables.myNewList = Variables.myNewList & "0">

     </cfif>

</cfloop>

<cfelse>

     <cfset Variables.myNewList = RepeatString(0,recordset.recordCount)>

</cfif>

I prepend the list with an "_" so that it will not convert the string to a number and thus remove any leading 0's.

This will achieve what you are looking for.  However unless there is a VERY specific need to have the characters put in a certain position, I would strongly advise a modified approach.

Sincerely,

Braden

You are really doing things the hard way.  It would be much easier if you gave all the checkboxes in each group the same name and different values.

I don't quite understand how you get 101 from admin_1 and admin_3.