cfgrid / cfgridupdate error with an invalid datatype

Ask a Question related to Coldfusion Flash Integration, Design and Development.

  1. #1

    Default cfgrid / cfgridupdate error with an invalid datatype

    I have a problem using cfgrid.

    I'm getting the following error message:
    ?Error casting an object of type to an incompatible type. This usually
    indicates a programming error in Java, although it could also mean you have
    tried to use a foreign object in a different way than it was designed.?

    The error occurs when I run this code:

    <cfif IsDefined("form.gridEntered")>
    <cfgridupdate grid="FirstGrid" dataSource="#dsn#" Keyonly="true"
    tableName="tblManager">
    </cfif>

    It is connecting to a mySQL 4.1 database.

    I think the problem is to do with a field I've added called ?Active? of
    datatype INT(1). I am using this as a boolean as as far as I'm aware, this is
    the nearest equivalent in mySQL.

    In my <cfgrid> I have added the following column.

    <cfgridcolumn name="Active" type="boolean" display="yes" width="40"
    header="On" bold="true" />

    Which shows a tickbox and is the look I want to achieve on the grid.
    I think this is causing the Java error. What do I need to do to allow
    submission to the grid of this datatype, please?

    Thank you for your time and help.

    magicmerlyn Guest

  2. Similar Questions and Discussions

    1. #39302 [NEW]: integer/datatype error
      From: paul at takizo dot com Operating system: FreeBSD 6.1 Released PHP version: 5.1.6 PHP Bug Type: Math related Bug...
    2. cfgrid / cfgridupdate problems
      I've got a simple query to a MS Access 2003 database. I want to be able to edit records using cfgrid. I am able to delete records without problem....
    3. CFMX 7 cfgrid / cfgridupdate help
      I can't seem to get CFMX 7's Flash cfgrid / cfgripdupdate combination to work. Maybe I just don't understand how it's supposed to work, but I...
    4. CFGRID/cfgridupdate code needed
      .. I would like to make a grid in flash format that will display records from a sql server table and let the users update rows and update the...
    5. cfgrid and cfgridupdate... archieving changes
      Hi, I am attempting to use the very cool cfgrid command for the first time. However, my problem is the following: I want to archieve all...
  3. #2

    Default Re: cfgrid / cfgridupdate error with an invalid datatype

    To answer my own question on this...
    cfgridupdate wasn't working so I wrote a regular block of code to make the required changes when submitting a grid.
    magicmerlyn Guest

Posting Permissions

  • You may not post new threads
  • You may 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