p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Professional (http://p2p.wrox.com/forumdisplay.php?f=63)
-   -   Update Record Not Working (http://p2p.wrox.com/showthread.php?t=100184)

dalezjc March 25th, 2019 12:27 PM

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



All times are GMT -4. The time now is 10:32 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.