Cfinput checkbox checked

checkbox coldfusion cfinput
stuttsdc picture stuttsdc · Feb 3, 2011 · Viewed 11.7k times · Source

I can't quite get this to work.

My form has a number of inputs including one checkbox. In my cfquery, I just want to write some simple SQL content that tests to see if the checkbox is checked or not. But my code just ignores it completely. Here's the basics:

<cfform name="form" action="...." format="HTML">
     ....
     <cfinput type="checkbox" name="search_NR" id="search_NR" checked="no" />
    <cfinput type="submit" name="submit"  value="Search" />
</cfform>

My cfquery is quite extensive, so I'll just put the part relevant to the checkbox here:

    <cfif isDefined("form.search_NR")>
        AND (tblMain.NR = true)
    </cfif>

My thought was that the box wouldn't be defined if it wasn't checked. But whether or not I check the box on the form, the query just ignores this altogether. I just want to add tblMain.NR = TRUE to the rest of the SQL content when the box is checked.

Answer

Stefano D picture Stefano D · Feb 3, 2011 
<cfif StructKeyExists(form, "search_NR")>
    AND (tblMain.NR = true)
</cfif>

Related questions

How do I check whether a checkbox is checked in jQuery?

I need to check the checked property of a checkbox and perform an action based on the checked property using jQuery. For example, if the age checkbox is checked, then I need to show a textbox to enter age, else …

Read More
Setting "checked" for a checkbox with jQuery

I'd like to do something like this to tick a checkbox using jQuery: $(".myCheckBox").checked(true); or $(".myCheckBox").selected(true); Does such a thing exist?

Read More
Check if checkbox is checked with jQuery

How can I check if a checkbox in a checkbox array is checked using the id of the checkbox array? I am using the following code, but it always returns the count of checked checkboxes regardless of id. function isCheckedById(…

Read More