Okay, it's definitely been one of those days... I'm having a hard time
making these checkboxes work. Can anybody see something obvious wrong?
--
<cfquery name="attendee" datasource="#DSN#">
SELECT attendee.*, users.id AS users_id, users.lname, users.fname
FROM attendee, users
WHERE attendee.assigneddate = #url.id# and users.id = attendee.users_id
ORDER BY users.lname, users.fname ASC
</cfquery>
<CFPARAM NAME="FORM.attended" default="0">
<CFPARAM NAME="FORM.withdrawn" default="0">
<CFPARAM NAME="FORM.paymentcleared" default="0">
<CFPARAM NAME="FORM.assignrec1" default="0">
<CFPARAM NAME="FORM.assignrec2" default="0">
<CFPARAM NAME="FORM.assignrec3" default="0">
<CFPARAM NAME="FORM.pretest" default="0">
<CFPARAM NAME="FORM.skilltest1" default="0">
<CFPARAM NAME="FORM.skilltest2" default="0">
<CFPARAM NAME="FORM.skilltest3" default="0">
<cfif attendee.assignrec1 EQ 1><CFSET checked4="Yes"><CFELSE><CFSET
checked4="No"></CFIF>
<cfif attendee.assignrec2 EQ 1><CFSET checked5="Yes"><CFELSE><CFSET
checked5="No"></CFIF>
<cfif attendee.assignrec3 EQ 1><CFSET checked6="Yes"><CFELSE><CFSET
checked6="No"></CFIF>
<cfif attendee.pretest EQ 1><CFSET checked7="Yes"><CFELSE><CFSET
checked7="No"></CFIF>
<cfif attendee.skilltest1 EQ 1><CFSET checked8="Yes"><CFELSE><CFSET
checked8="No"></CFIF>
<cfif attendee.skilltest2 EQ 1><CFSET checked9="Yes"><CFELSE><CFSET
checked9="No"></CFIF>
<cfif attendee.skilltest3 EQ 1><CFSET checked10="Yes"><CFELSE><CFSET
checked10="No"></CFIF>
<table>
<cfoutput query="attendee">
<form name="grading" action="grading.cfm?id=#courses.id#" method="post">
<tr>
<td><input type="checkbox" value="1" name="assignrec1"
checked="#checked4#" /></td>
<td><input type="checkbox" value="1" name="assignrec2"
checked="#checked5#" /></td>
<td><input type="checkbox" value="1" name="assignrec3"
checked="#checked6#" /></td>
<td><input type="checkbox" value="1" name="pretest"
checked="#checked7#" /></td>
<td><input type="radio" name="attended" value="Yes" <cfif
attendee.attended IS 'yes'>checked</cfif>> Yes <input type="radio"
name="attended" value="No" <cfif attendee.attended IS
'no'>checked</cfif>> No</td>
<td><input type="radio" name="withdrawn" value="Yes" <cfif
attendee.withdrawn IS 'yes'>checked</cfif>> Yes <input type="radio"
name="withdrawn" value="No" <cfif attendee.withdrawn IS
'no'>checked</cfif>> No</td>
<td><input type="text" name="writtentest1"
value="#attendee.writtentest1#" size="3" class="text" />%</td>
<td><input type="text" name="writtentest2"
value="#attendee.writtentest2#" size="3" class="text" />%</td>
<td><input type="text" name="writtentest3"
value="#attendee.writtentest3#" size="3" class="text" />%</td>
<td><input type="checkbox" value="1" name="skilltest1"
checked="#checked8#" /></td>
<td><input type="checkbox" value="1" name="skilltest2"
checked="#checked9#" /></td>
<td><input type="checkbox" value="1" name="skilltest3"
checked="#checked10#" /></td>
<td><input type="submit" value="Update This User" /></td>
</tr>
</form>
</cfoutput>
</table>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
