sysadmin07
IS-IT--Management
Hi,
I have a CF page that allows me to edit records in a MS Access database (the primary key in the database is autonumber-based). If I try to edit one row of the database from my CF page, everything works fine. However, if more than one row needs edited and is displayed on my CF page, upon clicking the "Submit" button (which invokes a cfupdate page) I get the following error (where, in this case, 1 and 2 are the primary keys of two, separate rows in the database):
Invalid data 1,2 for CFSQLTYPE CF_SQL_INTEGER
Any ideas why this may be happening?
Thank you.
I have a CF page that allows me to edit records in a MS Access database (the primary key in the database is autonumber-based). If I try to edit one row of the database from my CF page, everything works fine. However, if more than one row needs edited and is displayed on my CF page, upon clicking the "Submit" button (which invokes a cfupdate page) I get the following error (where, in this case, 1 and 2 are the primary keys of two, separate rows in the database):
Invalid data 1,2 for CFSQLTYPE CF_SQL_INTEGER
Any ideas why this may be happening?
Thank you.