I like to use cfparam in these case like above.
<cfparam name="form.delegations" value="#yourQuery.columnname#" />
And in HTML:
<input type="checkbox" name="delegations" id="SR1" value="0" <cfif listFind(form.delegations,0)>checked</cfif> />
Please note, in your database the value will be a list of values from checkboxes delegations.
1
solved Return checked checkboxes when user retrieves the form (Coldfusion) [closed]