I have a checkbox input value.
<CFFORM ACTION ="individual_minicab_registration_processing.cfm" METHOD="POST">
<td><input type="checkbox" name="creditcard" value="yes" CHECKED></td>
The value is set to checked, however if i uncheck the value, when the form processes I get an error "The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (7:1) to (11:57)"
On my action page I have a CFPARAM (<CFPARAM NAME="creditcard" default="No">) which i thought would set the value to No if the checkbox was unchecked.
I know what is happening in that the database does not recognize the value if the box is unchecked. I want the databaes to recognize the value as False whe nthe box is unchecked.
<CFFORM ACTION ="individual_minicab_registration_processing.cfm" METHOD="POST">
<td><input type="checkbox" name="creditcard" value="yes" CHECKED></td>
The value is set to checked, however if i uncheck the value, when the form processes I get an error "The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (7:1) to (11:57)"
On my action page I have a CFPARAM (<CFPARAM NAME="creditcard" default="No">) which i thought would set the value to No if the checkbox was unchecked.
I know what is happening in that the database does not recognize the value if the box is unchecked. I want the databaes to recognize the value as False whe nthe box is unchecked.