Form entries incomplete or invalid

[smokin_joe]

I am trying to Insert the value of a "checkbox " field to the database
(MSACCESS) using, i.e. on the Form Page:
<input type="checkbox" name="Muzzle_Order_Issued" value="Yes">

On the InsertPage I have defined :
<CFPARAM NAME="Muzzle_Order_Issued" DEFAULT="">[ incase the value is not
present on the form]

And the insert as:
<CFINSERT dataSource="#Request.dsn#" tableName="t_vet"
formfields="Muzzle_Order_Issued>

The database field type for Muzzle_Order_Issued is "Text".

Why would I get the following error ?

Form entries incomplete or invalid.
The value entered for the MUZZLE_ORDER_ISSUED field ('Yes') is not correctly
formatted.
Debugging Information
500 Form entries incomplete or invalid.
Form entries incomplete or invalid.

One additional thought.... could the MSAccess DB be corrupted somehow.... it
does have one table with over 70,000 records, that I reacently added a key
field to. I did this after Access grumbeled about a "Lock" file that had to be
increased??

[sdupre]

<CFPARAM NAME="Muzzle_Order_Issued" DEFAULT="">

I think it might be a scoping problem.

<CFPARAM NAME="FORM.Muzzle_Order_Issued" DEFAULT="">

Stephen Dupre
Macromedia QA

[CFLoser]

smokin,
Do you also have a form entry called "Muzzle_Order" in the same form?
I have found some quirks in CF that involve form variables with "_date"
and maybe others.
I can get the same error with two form variables :
Target_Status
Target_Status_Date

Iit complains: Form entries incomplete or invalid The value entered for
the TARGET_STATUS field ('ANALYSIS') is not correctly formatted.

I removed the form Field Target_Status_Date and everything worked fine.
I am wondering if " _Issued" has problems also.

I think CF is trying to be clever with their hidden _Date validation
routines. Because this comes up once the submit key is hit and before the next
page is executed.

[GameDev]

After having read this forum (though it is old) I though I would share my
experience as well for anyone else running into the:
'Invalid input in field 'blab'". As it turned out, the use of '_' in our
column names were being flagged by ColdFusion. Before your form submission even
got to a query (SQL or otherwise) CF was trying to validate the input even
though it was not a CFInput, just a regular HTML one. Hope this helps others.
We simply removed our underscores and solved the issue.

-Tyler