build_sys_mod_change_do.asp

来自「能实现用户注册」· ASP 代码 · 共 18 行

<%
'on error resume next
s_Item_No=request.querystring("s_Item_No")

%><!-- #INCLUDE FILE="odbc_connection.inc" --><%

'change
sSQL="UPDATE tbl_Inventory_System_Components_Session"
sSQL=sSQL & " SET"
sSQL=sSQL & " s_Component_Item_No='" & s_Item_No & "'"
sSQL=sSQL & " WHERE intKey=" & session("intKey")
set RS=conn.execute(sSQL)
set RS=nothing

'go back to display new total, await more changes, etc.
session("repeat")=1
response.redirect "build_sys_mod.asp"
%>