cfupdate and checkboxes

[sevex]

I'm using cfupdate to update some records that use a checkbox (yes/no) field. The problem is that if the field is "on" and I uncheck the checkbox then use cfupdate, it doesn't set the field to "off". But the opposite works fine.

Is there any way to have cfupdate and checkboxes co-operate with each other?

 

[tleish]

Try setting the default value of the checkbox to false before calling <cfupdate>

<cfparam name=&quot;form.myCheckBox&quot; default=&quot;False&quot;>

code...

<cfupdate...> - tleish

 

[sevex]

I was afraid I'd end up doing something like that... there's just so... many... checkboxes...

sigh

Thanks though, I'll give that a shot.

 

[tleish]

What about setting them using a list, less code:

=== START CODE EXAMPLE ===
<cfloop list=&quot;checkbox1,checkbox2,checkbox3...&quot; index=&quot;i&quot;>
<cfparam name=&quot;form

[

i

]

&quot; default=&quot;False&quot;>
</cfloop>
=== END CODE EXAMPLE === - tleish

 

[sevex]

I thought of that, but wasn't sure how so I just did it without. It works great, thanks again.

I'll try that list thing later however. Soon I get to make this thing searchable