tjfy_update.asp

十分好的音乐网站源码 十分好的音乐网站源码十分好的音乐网站源码十分好的音乐网站源码十分好的音乐网站源码

<%
if session("cjuser")="" and session("pwdd")="" then
response.write"<SCRIPT language=JavaScript>alert('你没有登录，无权进入！');"
response.write"this.location.href='error.htm';</SCRIPT>" 
response.end 
end if
%>
<%response.buffer=true%>
<!--#include file=../conn/adodb1.asp -->
<%
dim id
id=session("id")
dim xxlx,fylx,qy,wz,jzmc,xxdz,fylb,fwmj,zlc,szc,fwfx,qt,jg,dw,fjf,fkfs,sfdk,cq,s,t,w,ty,ccs,ck,yt,fbsj,lxr,lxdh,bz
fybm=trim(request.form("fybm"))
xxlx=trim(request.form("xxlx"))
fylx=trim(request.form("fylx"))
qy=trim(request.form("qy"))
wz=trim(request.form("wz"))
jzmc=trim(request.form("jzmc"))
xxdz=trim(request.form("xxdz"))
fylb=trim(request.form("fylb"))
fwmj=trim(request.form("fwmj"))
zlc=trim(request.form("zlc"))
szc=trim(request.form("szc"))
fwfx=trim(request.form("fwfx"))
qt=trim(request.form("qt"))
jg=trim(request.form("jg"))
dw=trim(request.form("dw"))
fjf=trim(request.form("fjf"))
fkfs=trim(request.form("fkfs"))
sfdk=trim(request.form("sfdk"))
cq=trim(request.form("cq"))
s=trim(request.form("s"))
t=trim(request.form("t"))
w=trim(request.form("w"))
ty=trim(request.form("ty"))
ccs=trim(request.form("ccs"))
ck=trim(request.form("ck"))
yt=trim(request.form("yt"))
lxr=trim(request.form("lxr"))
fbsj=now()
lxdh=trim(request.form("lxdh"))
bz=trim(request.form("bz"))

sql="update tjfy set xxlx='"& xxlx &"',fybm='"& fybm &"',fylx='"& fylx &"',qy='"& qy &"',wz='"& wz &"',jzmc='"& jzmc &"',xxdz='"& xxdz &"',fylb='"& fylb &"',fwmj='"& fwmj &"',zlc='"& zlc &"',szc='"& szc &"',fwfx='"& fwfx &"',qt='"& qt &"',jg='"& jg &"',dw='"& dw &"',fjf='"& fjf &"',fkfs='"& fkfs &"',sfdk='"& sfdk &"',cq='"& cq &"',s='"& s &"',t='"& t &"',w='"& w &"',ty='"& ty &"',ccs='"& ccs &"',ck='"& ck &"',yt='"& yt &"',fbsj='"& fbsj &"',lxr='"& lxr &"',lxdh='"& lxdh &"',bz='"& bz &"' where id=cstr('"& id &"')"
db.execute(sql)

response.redirect "tjfy_manage.asp"

%>