jillian...
<input type="checkbox" value="1" name="assignrec3" <cfif yes is yes>checked</cfif>/> its a checked word at the end, not a parameter of the element :) try that. tw -----Original Message----- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 11:04 PM To: CF-Talk Subject: Checkbox Problem 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
