Highlighted

CFGRID passing wrong update IDs

Explorer ,
Jun 16, 2014

Copy link to clipboard

Copied

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

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

Views

109

Likes

Translate

Translate

Report

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

CFGRID passing wrong update IDs

Explorer ,
Jun 16, 2014

Copy link to clipboard

Copied

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

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

Views

110

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 16, 2014 0
Explorer ,
Jun 17, 2014

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 17, 2014 0