- see footer for list info -<
I have a page that shows some checkboxes...
<table border="0" width=100% cellpadding="3" class="itemTable">
<!--- Type of incident --->
<tr>
<td colspan="3" valign="top" align="left"
bgcolor="#cceaff">
<b>Is this bullying:</b>
<i>Select all that apply</i>
</td>
</tr>
<tr>
<td valign="top" align="left"
bgcolor="#cceaff" width="33%">
<cfinput type = "checkbox" name =
"BullyingType" value = "1">
Racist
</td>
<td valign="top" align="left"
bgcolor="#cceaff" width="33%">
<cfinput type = "checkbox" name =
"BullyingType" value = "2">
Homophobic
</td>
<td valign="top" align="left"
bgcolor="#cceaff">
<cfinput type = "checkbox" name =
"BullyingType" value = "3">
Disablist
</td>
</tr>
<tr>
<td valign="top" align="left"
bgcolor="#cceaff">
<cfinput type = "checkbox" name =
"BullyingType" value = "4">
Religiously motivated
</td>
<td valign="top" align="left"
bgcolor="#cceaff">
<cfinput type = "checkbox" name =
"BullyingType" value = "5">
Cyber (Mobile phone,
email)
</td>
<td valign="top" align="left"
bgcolor="#cceaff">
<cfinput type = "checkbox" name =
"BullyingType" value = "9">
Other
(Please Specify)
<cfinput type="text"
size="35"
name="IncidentTypeOther">
</p>
</td>
</tr>
</table>
The data from these check boxes is held in a table like this ....
BullyingIDPK IncidentIDFK BullyingType
50 196 1
51 196 2
52 196 4
I now want to create a modify form that will show what the checkboxes were
set to originally.
Im not sure how to do this in this instance ....
Do I query the table (Which will return 3 records) and then some sort of
loop checking the value against each input or maybe put the query result in
a list and loop over the list?
Im sure there's an easy way of doing this ...
Any suggestions .... ?
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
