Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

cfgridcolumn select breaks table

New Here ,
Jun 08, 2012 Jun 08, 2012

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.

559
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 08, 2012 Jun 08, 2012

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 08, 2012 Jun 08, 2012
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources