all groups > coldfusion flash integration > may 2007 >
You're in the

coldfusion flash integration

group:

cfgrid / cfgridupdate error with an invalid datatype


cfgrid / cfgridupdate error with an invalid datatype magicmerlyn
5/9/2007 3:14:02 PM
coldfusion flash integration:
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.
Re: cfgrid / cfgridupdate error with an invalid datatype magicmerlyn
5/11/2007 12:00:00 AM
To answer my own question on this...
AddThis Social Bookmark Button