Skip to main content
Inspiring
June 16, 2014
Answered

CFGRID passing wrong update IDs

  • June 16, 2014
  • 1 reply
  • 256 views

I have a CFGRID in a small app that is passing wrong update information.  This is causing the updates to happen in the wrong rows in the data table. 

Anyone have any ideas what could cause this?

EXAMPLE:

Grid has 300+ rows

Select item with ID 103 and edit a value withing the data (happens to be decimal(8,2) in SQLServer

Select and edit ID 104

On submit of changes, the data getting updated in the table is row 104 and row 108 !!!

The ID row is set as primary key

I have used cfgrid in other scenarios without issue.

Version is CF10

Same happens whether I use CFGRIDUPDATE or use the passed form fields and update via SQL.

Any thoughts?  Ideas?  This is very frustrating.

Thanks in advance.

Pete

    This topic has been closed for replies.
    Correct answer planomax

    I switched from HTML to Flash and used IE instead of Chrome and now it is working.  I would still like to know if anyone else is seeing this issue?

    Pete

    1 reply

    planomaxAuthorCorrect answer
    Inspiring
    June 17, 2014

    I switched from HTML to Flash and used IE instead of Chrome and now it is working.  I would still like to know if anyone else is seeing this issue?

    Pete