sj_save_edit.asp

北京商务网

<%@ codepage ="936" %>
<!--#include file="../../conn/dbconn2.asp"-->
<%
dim bighy
dim lithy
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
bighy=request("bighy")
lithy=request("lithy")
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("sortid")=bighy
  rs("typeid")=lithy
  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"%>