This topic is locked
[SOLVED]

 UPDATE statement is not wotking after version UPGRADE

11/13/2017 10:13:34 AM
ASPRunnerPro General questions
V
VORONOY author

Updated and migrated projects from ASPRunnerPro 7.1 to ASPRunnerPro 9.8
Suddenly, SQL Update statements stopped working in After Record Added and from stand alone asp file from POST.
After record Added:
strSQL = "UPDATE TABLE_NAME SET name=0 WHERE id=" & Session(strTableName &"_masterkey1")

dbConnection.Execute strSQL
Stand alone file:
<%

%>

<!--#include file="include/dbcommon.asp"-->

<%

dim fid

fid=Request.Form("id")

sql = "Update TABLE_NAME set name=1 where id=" & fid & ""

dbConnection.Execute sql

%>
Anything changed in 9.8? Rebuilded the project with 7.1 - Everything back to normal and working.

V
VORONOY author 11/14/2017



Updated and migrated projects from ASPRunnerPro 7.1 to ASPRunnerPro 9.8
Suddenly, SQL Update statements stopped working in After Record Added and from stand alone asp file from POST.
After record Added:
strSQL = "UPDATE TABLE_NAME SET name=0 WHERE id=" & Session(strTableName &"_masterkey1")

dbConnection.Execute strSQL
Stand alone file:
<%

%>

<!--#include file="include/dbcommon.asp"-->

<%

dim fid

fid=Request.Form("id")

sql = "Update TABLE_NAME set name=1 where id=" & fid & ""

dbConnection.Execute sql

%>
Anything changed in 9.8? Rebuilded the project with 7.1 - Everything back to normal and working.


RESOLVED: Using CustomQuery(sql) instead of dbConnection.Execute sql