sj_save_edit.asp

asp+access开发的网上购物程序

<%@ codepage ="936" %>
<!--#include file="../../conn/dbconn2.asp"-->
<%
dim showname
dim ppxh
dim jgsm
dim mmfx
dim period
dim content
dim linkman
dim company
dim address
dim email
dim phone
dim fax
dim postcode
dim web
dim city
dim country
dim rs
dim sql 
dim info_id
info_id=request("info_id")
showname=request("showname")
jgsm=request("jgsm")
ppxh=request("ppxh")
mmfx=request("type")
period=request("period")
content=request("content")
linkman=request("linkman")
company=request("company")
address=request("address")
email=request("email")
phone=request("phone")
country=request("country")
if trim(request("postcode"))="" then
post="空"
else
post=request("postcode")
end if
if trim(request.form("fax"))="" then
fax="空"
else
fax=request.form("fax")
end if
if trim(request.form("web"))="" then
web="空"
else
web=request.form("web")
end if
if trim(request("email"))="" then
email="空"
else
email=request("email")
end if 
city=request.form("city")
set rs=server.createobject("adodb.recordset")
sql="select * from info where info_id="&info_id
rs.open sql,conn,1,3
rs("showname")=showname
rs("jgsm")=jgsm
rs("ppxh")=ppxh
rs("type")=mmfx
rs("period")=period
rs("content")=content
rs("linkman")=linkman
rs("company")=company
rs("address")=address
rs("mail")=email
rs("phone")=phone
rs("fax")=fax
rs("postcode")=post
rs("country")=country
rs("web")=web
rs("city")=city
rs("dateandtime")=date()
rs.update
rs.close
set rs=noting
conn.close
set conn=nothing
response.redirect "sj_edit.asp"%>