Skip to main content
Participant
June 8, 2012
Question

cfgridcolumn select breaks table

  • June 8, 2012
  • 1 reply
  • 596 views

I'm using a cfgrid to make a table.  If I put in a select = no statement like:

<cfgridcolumn name = "bedNum" header = "Room" headerAlign = "center" width = "75" select = "no">

it returns an error:

Invalid data for CFSQLTYPE CF_SQL_INTEGER.

As soon as I take it out, the grid works fine when I submit an update of a row.  All i'm trying to do is not allow users to edit certain fields that are in the table but be able to alter others.

    This topic has been closed for replies.

    1 reply

    Inspiring
    June 8, 2012

    The documentation for the select attribute suggests that it's related to the selectmode attribute of the cfgrid tag.

    MIGhunterAuthor
    Participant
    June 8, 2012

    there is in the cfgrid tag the ability to make the table editable.  Then in the cfgridcolumn tag you are supposed to be able to make fields so that users can't selecct them.  That is what I am doing.  It works until I try to update one of the rows.