Thread: updating table
View Single Post
  #1 (permalink)  
Old September 29th, 2004, 05:29 AM
markhardiman markhardiman is offline
Authorized User
 
Join Date: Jul 2003
Location: Dublin, Ireland, Ireland.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default updating table

hi all
i have the following code

Set pb_RS=Server.CreateObject("ADODB.Recordset")
pb_SQL = "SELECT * FROM web_1 WHERE web_num= '" & SESSION("web_num") & "'"
pb_RS.Open pb_SQL, objConn, , adLockOptimistic

pb_RS.Fields("web_pb").value = SESSION("Valid")
pb_RS.Fields("web_pdate").value = Date
pb_RS.Fields("webr_stage").value = "Claimed"
pb_RS.Update

pb_RS.Close
Set pb_RS= Nothing

and i am trying to update a record already in a table. however when this code is run it changes the values for all records in the table. any ideas whats happening?

Slán
~M
____
Mark
Reply With Quote