Forums: [SOLVED] UPDATE statement is not wotking after version UPGRADE - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

[SOLVED] UPDATE statement is not wotking after version UPGRADE Rate Topic: -----

#1 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 17
  • Joined: 14-February 07

Posted 13 November 2017 - 03:13 PM

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.
0

#2 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 17
  • Joined: 14-February 07

Posted 14 November 2017 - 06:08 PM

View PostVORONOY, on 13 November 2017 - 10:13 AM, said:

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
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic