save_board.asp

购物系统(本版为正式商业版

<!--#include file="../conn2.asp"-->
<!--#include file="set.asp"-->
<%
bid=int(request("bid"))

logo=request.form("logo")
bidname=request.form("bidname")
bidinfo=request.form("bidinfo")
px=request.form("px")
rzh=request.form("advshow")
username=request.form("username")
if bidname="" or bidinfo="" then
response.write"<script language='javascript'>alert('请填写完整信息！')</script>"
response.write "<script language='javascript'>history.back(-1)</script>"
response.end
end if
if not IsNumeric(px) then
response.write"<script language='javascript'>alert('排序必须为数字！')</script>"
response.write "<script language='javascript'>history.back(-1)</script>"
response.end
end if

Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM board where bid="&bid 
rs.Open sql,conn,3,2
rs("bidname")=bidname
rs("logo")=logo
rs("px")=px
rs("bidinfo")=bidinfo
rs("rzh")=rzh
rs("username")=username
rs.update


set rs=nothing
set conn=nothing
response.redirect "boardman.asp"
%>