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