cfgridupdate

[community_help]

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c7c.html

[DannyGoodisman]

CFGRIDUPDATE only works if the database has a column defined as a primary key. It doesn't work on tables with no primary key defined, or a primary key that's defined separately from the column definitions.

If the CFGRID needs to update such a table, create a satisfactory temp table and then put the new data where it needs to go.