Retrieve checkbox value for database

[robman22]

When I submit my form, if the checkbox is checked, it shows as checked in the database, but when I retrieve my data, the checkbox on my for does not display as checked.

Any help?

 

[DarkMan]

Unfortunately, the checkbox parameter is not passed when it is not checked...

The best way to deal with this is on your form:

<input type=&quot;checkbox&quot; name=&quot;checkme&quot; value=1>

Then on your action page:

<cfparam name=&quot;checkme&quot; default=0>
<cfif checkme is 1>
  Checkbox was checked.
<cfelse>
  Checkbox was not checked.
</cfif>

Hope this helps... DarkMan

 

[iza]

i was using :

<input type=&quot;checkbox&quot; name=&quot;checkme&quot; value=1>

and in the action page
<cfif isdefined(&quot;checkme&quot>
checkbox was checked
<cfelse>
checkbox wasn't checked
</cfif>

just the same actually, i only don't create a variable if there's not