Professional Web Applications Themes

Form entries incomplete or invalid - Coldfusion Database Access

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 ...

  1. #1

    Default Form entries incomplete or invalid

    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??

    smokin_joe Guest

  2. #2

    Default Re: Form entries incomplete or invalid

    <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
    sdupre Guest

  3. #3

    Default Re: Form entries incomplete or invalid

    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 ('YSIS') 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.



    CFLoser Guest

  4. #4

    Default Re: Form entries incomplete or invalid

    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

    GameDev Guest

Similar Threads

  1. 500 Form entries incomplete or invalid
    By smokin_joe in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: July 19th, 08:17 PM
  2. Record Insertion Form causes multiple entries
    By BarryCrandall in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 15th, 10:41 PM
  3. Wizard type Form entries and underlying data set
    By Mark in forum Microsoft Access
    Replies: 2
    Last Post: July 29th, 07:13 PM
  4. Form - table entries
    By Jim Kennedy in forum Microsoft Access
    Replies: 3
    Last Post: July 10th, 06:47 PM
  5. Rounded entries on form
    By Pam Carney in forum Microsoft Access
    Replies: 0
    Last Post: July 8th, 04:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139