- see footer for list info -<
I think you hit it with the list.
From your query use valueList function to get all the values for bullytype
in a list
then in each checkbox can look something like this
<input type="checkbox" name="Forced to Use ASP" value="7"
#iif(listfind(yourlist,'7'),de('checked'),de(''))#>
the iif will put a 'checked' into any checkboxes that were previously
checked.
HTH
Mike T
On 5/5/06, Paul Swingewood <[EMAIL PROTECTED]> wrote:
>- 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
-<
--
Mike T
Blog http://www.socialpoints.com/
_______________________________________________
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 -<
