Retrieving Dynamic Field Names

tdaustin · January 12th, 2004, 12:53 AM

Hi Everyone,

I have created a dynamic check boxes where they can select muliple/ specific categories (stored on a db). I now need to retrieve the ones which they ticked. I have set the field id as the CategoryID and now need to retrive the field names that have been ticked. I relise i will need a For Loop, but how do i grab the FieldNames from the form that have been ticked.

Thanks Tim

*** Form Code ***
<input name="<%= objRSProject("ProjectID") %>" type="checkbox" id="<%= objRSProject("ProjectID") %>" value="yes">

TDA

rodmcleay · January 12th, 2004, 01:37 AM

Tim,
Yes you are right you need to loop through the forms collection and look for checked boxes, then their name will be available to you.
However the to to this efficiently you need to be able to destinguish what a checkboxes name might have in it and test to see if it is a check box first. So i tend to name my dynamic fields with a prefix like.
*** Form Code ***
<input name="chk_<%= objRSProject("ProjectID") %>" type="checkbox" id="chk_<%= objRSProject("ProjectID") %>" value="yes">

So when I loop though the form I can pull out the checkboxes test the values and cut the name up to get the original "ProjectID"

Code:

for each obj in request.form
if left request(obj,4) = "chk_" then 'we have a checkbox
 ProjectID = right(obj,len(obj)-4)
 chkBoxValue = request(obj)
 'Do stuff with the values
end if
loop

Hope this helps a bit

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

tdaustin · January 12th, 2004, 01:56 AM

Thanks Rod,

Thats exactly what i was after and also thanks for showing how to filter out other variables that may also contain Numeric values.

Tim :D

TDA

rodmcleay · January 12th, 2004, 02:06 AM

No worries

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

planoie · January 12th, 2004, 11:10 AM

Why not just use the value attribute of the checkbox? Only the checked checkboxes will be posted when the form is submitted. So you can create every checkbox with the same name/id, and simplify your loop by only checking that form field's value. Each checked checkbox's value will be separated by a ",".

<input name="chkChoosenField" type="checkbox" id="chkChoosenField" value="<%= objRSProject("ProjectID") %>">
...
aryFields = Split(Request("chkChoosenField"), ",")
For Each sField In aryFields
'Do stuff here
Next

Peter
------------------------------------------------------
Work smarter, not harder.