UC知道关于asp的加减SQL没有更新
来源：百度知道 编辑：UC知道 时间：2024/06/08 02:54:00
<!--#include file="conn.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='login.asp';</script>"
response.End
end if
%>
<%
dim rs5,num,name,bedname,xueyuan,major,class1,sex,ruxue,nation,jiguang,xueli,political,address,phone,jiaofei,rs,sql,rs1,sql1,rs4,sql4
num=trim(request("a1"))
name=trim(request("a2"))
bedname=trim(request("a3"))
xueyuan=trim(request("a4"))
major=trim(request("a5"))
class1=trim(request("a6"))
sex=trim(request("a7"))
ruxue=trim(request("a15"))
nation=trim(request("a8"))
jiguang=trim(request("a9"))
xueli=trim(request("a10"))
political=trim(request("a11"))
address=trim(request("a12&qu
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='login.asp';</script>"
response.End
end if
%>
<%
dim rs5,num,name,bedname,xueyuan,major,class1,sex,ruxue,nation,jiguang,xueli,political,address,phone,jiaofei,rs,sql,rs1,sql1,rs4,sql4
num=trim(request("a1"))
name=trim(request("a2"))
bedname=trim(request("a3"))
xueyuan=trim(request("a4"))
major=trim(request("a5"))
class1=trim(request("a6"))
sex=trim(request("a7"))
ruxue=trim(request("a15"))
nation=trim(request("a8"))
jiguang=trim(request("a9"))
xueli=trim(request("a10"))
political=trim(request("a11"))
address=trim(request("a12&qu
set rs5.update
前面的 set 去掉
=============================
select * from room where roomname like '"&leftb(bedname,14)&"%'
你这样更新的话~`如果出现的是一系列数据~`所以程序不知道更新哪一条~`除非是批量更新