>hi all
>i have the following code. it works on page1.asp perfectly, only updating one record, however on page two it updates most records in the table. this is the exact same code char-4-char on the 2 pages, i am really stumped, any ideas?
>
>Dim step3_RS, step3_SQL
>Set step3_RS=Server.CreateObject("ADODB.Recordset")
>step3_SQL = "SELECT per_stage FROM web_permit WHERE per_num= '" & SESSION("USER_PERMIT") & "'"
>step3_RS.Open step3_SQL, objConn, , adLockOptimistic
>
>step3_RS ("per_stage") = "Claimed"
>step3_RS.Update
>
>Slán
>~M

Mark;

You know your needs and application design so I am just voicing my opinion from what I see and know. I can only see this code so I am basing my suggestion upon it. I try to avoid Session.

I would not use the Session() in the select statement. Would removing Session be a serious problem?

Tom