build_sys_mod_change_sys_price.asp

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

<%
'on error resume next

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

Num=request.form("System_Price")
Num=replace(Num,"$","")
Num=replace(Num,",","")

sSQL="UPDATE tbl_Inventory"
sSQL=sSQL & " SET"
sSQL=sSQL & " Price=" & Num
sSQL=sSQL & " WHERE s_Item_No='" & session("s_System_Item_No") & "'"
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"
%>