Populating checkboxes

[Archuaakash23]

I have a form with a list of checkboxes. The form is created dynamically from a database and the checkboxes are assigned to each item that is returned in the database (each item has a unique ID). I also have another database field which contains an array of numbers (eg. 1,2,33,34). How can I check the checkboxes in my dynamic form corresponding to the numbers in the array. eg. if the array is 1,2,33,34 how can boxes 1,2,33,34 be checked.

I am using ASP , and javascript

Thanks in advance

[jhardman]

I would first assign the array of numbers to be checked to a variable:

dim checkedNumbers 
checkedNumbers = split (objRS("selectedFields"), ",")
'checkedNumbers(0) now equals "1" , checkedNumbers(1) = "2" etc.
 

Then as I make the list of checkboxes I would check each ID against the checkedNumbers array:

dim i
i = 0
do until objRS.eof %>
   <li><%=objRS("ID")%> <input type="checkbox" name="<%=objRS("ID")%>
   <%
   if cstr(objRS("ID")) = checkedNumbers(i) then
      response.write "checked"
      i = i + 1
   end if %>
   ></li>
   <%
   objRS.moveNext
loop
 

Of course this will only work if the array is in the same order as the records you are checking. The other way to do it would be to place the array in a single variable:

dim checkedNumbers 
checkedNumbers = "," & objRS("selectedFields")& ","

then the logical statement becomes:

   if instr(checkedNumbers, "," & cstr(objRS("ID")) & ",")>0 then

Does this make sense?

Jared