Thread: updating table
View Single Post
  #2 (permalink)  
Old September 29th, 2004, 09:49 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Try to response.write SESSION("web_num"), and see if that hold any value.

A better way is to try this.
Code:
pb_SQL = "SELECT * FROM web_1 WHERE web_num= '" & SESSION("web_num") & "'"
Response.write pb_SQL
Response.end
pb_RS.Open pb_SQL, objConn, , adLockOptimistic
Now copy/paste the resulting SQL statement and execute that on query analyser and see what it results, that would give you some idea on what is going wrong. Also confirm if you are using any Loop to do your update there.

Hope that helps.
Cheers!


_________________________
- Vijay G
Strive for Perfection
Reply With Quote