Webmaster Forum / ColdFusion / Advanced Techniques / March 2006

Hi,
I hope someone could help me because I have no clue how to fix this problem
and I'm in need of some assistance.
Heres the situation, I have a form and in the form i have checkbox and
basically the way I have it set up on my web page is I will search for
something in the database and whether its a yes or no (1 or 0, true or false)
in the database the checkbox on the web page will either be checked or
unchecked. I do this like this:

<form name="whatever" method="post">   
     My Checkbox:<br>
     <cfoutput query="myqueryname">
          <cfif myqueryname.something is 1>
               <input name="checkbox" type="checkbox" value="checkbox" checked>
          <cfelse>
               <input name="checkbox" type="checkbox" value="checkbox">
          </cfif>
     </cfoutput>
     <input type="submit" name="submit" value="Update">
</form>

The purpose of the web page is to be able to check and uncheck the checkbox
and update the changes in the database through the web page. However, my code
is not working because when I attempt to do this I get this error:
Element CHECKBOX is undefined in FORM.

and it points to this part of my code:

<cfquery name="aqueryname" datasource="thesource">
update thetable
set thefield='#form.checkbox#'
where name='thename'
</cfquery>

I'm not sure if I provided enough information but any type of help will be
much appreciated.
Thank you.