Similar Issue as this Post:
http://www.asprunner.com/forums/index.php?...p;hl=Edit+Error
Hey Sergey,
I am having a similar problem with (edit)updating records.
I created a website that allows user to edit records and move records to a different status.
My main page (mySystemName_list.asp) pulls all records from SQL with Status 'Pending'. Each record has a link (Edit) that allow users to edit record. That page is called (mySystemName_edit.asp). I have no issue to edit and save the changes here.
One of the options in mySystemName_edit.asp is to change a field (Status) from 'Pending' to 'Completed'.
I created a view (Completed_Records_list.asp) which pull all records from SQL with Status 'Completed'. Each record has a link (Edit) that allow users to edit record, too. That page is called (Completed_Records_edit.asp). I can see on the URL ....asp?editid1=(RecordsID). However, when I try to save changes in this page I get the following error:
<<< Record was NOT edited >>>
Item cannot be found in the collection corresponding to the requested name or ordinal.
This usually means that the SQL can't find the unique record to update, but I see the record ID is being passed in so it available for the SQL update query.
Please advise,
Noel Rijo
Mount Sinai Medical Center
School of Medicine
