View Single Post
  #1 (permalink)  
Old March 25th, 2019, 12:27 PM
dalezjc dalezjc is offline
Authorized User
Points: 287, Level: 5
Points: 287, Level: 5 Points: 287, Level: 5 Points: 287, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2006
Location: Colorado Springs, CO
Posts: 60
Thanks: 1
Thanked 0 Times in 0 Posts
Default Update Record Not Working

Hello All,


Been awhile since I posted! (Haven't had a chance to use ASP in a while.)


Anyway, I'm trying to update a record my SQL database and the update APPENDS the new data to the existing column data. Here's the update statement:


Code:
sql="UPDATE noi_kb SET "
sql=sql & " Problem_Status = '" & request.form("Problem_Status") & "' ,"
sql=sql & "resolution='" & Request.Form("resolution") & "' "
sql=sql & " WHERE row_id = '" & row_id & "' "
Connnoikb.Execute sql

Last edited by dalezjc; March 27th, 2019 at 11:16 AM..
Reply With Quote