> 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]
>
Make the default value 0 or No
> And the insert as:
> <CFINSERT dataSource="#Request.dsn#" tableName="t_vet"
> formfields="Muzzle_Order_Issued>
>
Be sure to include the trailing quote (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.
I would also modify your code to specify the form scope. It's good programming
etiquette and will help avoid future debugging difficulty. Try this:
<CFPARAM NAME="form.Muzzle_Order_Issued" DEFAULT="0">
<CFINSERT dataSource="#Request.dsn#" tableName="t_vet"
formfields="Muzzle_Order_Issued">
Dave
******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1310
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
