But it is not the way i want.. i have one asp page which allow user to modify any of the fileds value after login.. I first scan the user details and shows up in one form and want user to update the profile...
This is what i am doing..
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "clp,conn, , ,adCmdtable
bolfound = false
Do while NOT (rs.EOF OR bolfound)
if( Strcomp(rs("screenname"), Session("screenname"),vbtextcompare)= 0) then
bolfound = true
and then records listing are displaying like..
and at end..
hope this time.. i am much more clearer then earlier..
I think that the problem is the cursor type you are using. You may use the default cursor which is adOpenForwardOnly. This cursor only allows you to navigate forward in the recordset and does not allow updates to the recordset. My suggestion is that you need to change the cursor type to adOpenKeySet (=1) or adOpenDynamic (=2) with the lock type of adLockPessimistic (=2) or adLockOptimistic (=3). Note that there is a price to pay for using adOpenDynamic since the database must provide all changes to the data to your cursor while it is open.