Hi, I need some help here. Please enlighten me.
I've been using cfquery to do updating/deleting/inserting, recently, i tried cfgridupdate.
What i have is a simple query. Follow by a CFGRID to display the result. With 'EDIT' mode, i managed to edit/delete/add within the grid. Finally, submit the form with all the changes. And, i've CFGRIDUPDATE on the action page. Supposely, the tag should reflect the changes back to the database.
However, it doesn't work and i got some error like this:
Primary key field ROWID not found.
The field ROWID was not found in the Grid input. This
field is required in order to do an UPDATE or DELETE
because it is part of the primary key for the table.
Does it mean that i've to retrieve the ROWID in my query & grid? But after trying, still doesn't work. To my understanding, seems that CFGRIDUPDATE use primary key to identify the record being update. FYI, i'm using ORACLE database (which always use rowid to uniquely identify the record).
I've been using cfquery to do updating/deleting/inserting, recently, i tried cfgridupdate.
What i have is a simple query. Follow by a CFGRID to display the result. With 'EDIT' mode, i managed to edit/delete/add within the grid. Finally, submit the form with all the changes. And, i've CFGRIDUPDATE on the action page. Supposely, the tag should reflect the changes back to the database.
However, it doesn't work and i got some error like this:
Primary key field ROWID not found.
The field ROWID was not found in the Grid input. This
field is required in order to do an UPDATE or DELETE
because it is part of the primary key for the table.
Does it mean that i've to retrieve the ROWID in my query & grid? But after trying, still doesn't work. To my understanding, seems that CFGRIDUPDATE use primary key to identify the record being update. FYI, i'm using ORACLE database (which always use rowid to uniquely identify the record).