i have this problem that i havent been able to solve for almost a week now.....
i am designing this SQL server backend & ASP frontend software....
how do i update several fields at a time concurrently from the ASP??? the update query needs a primary key for the row to be selected but that primary key is being generated by SQL server as a counter.....so i am just defining the variable where this primary key is being stored. <%=rs(call_id))%> call_id being 1,2,3... upon generation

how do i select attributes pertaining to a particular call_id so that i make changes in that row upon pressing the save button?

Hi there,

I am not sure I understand what your problem is. Can you elaborate on the situation a bit more?
Are you trying to create an update page and looking for a way to retrieve the original Primary Key again to determine which record to update?

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.