找错误。。。谁找对了就把分都给他!
这是一个交接班的验证页面
其中四人交接
但是不一定四人都在
至少两个吧。
主要请各位看看有没有语法 逻辑错误 多谢啊!
<%@language=vbscript%>
<!--#include file="../../conn/conn.asp" -->
<%
if session("username")="" then
response.redirect "../../default.asp"
end if
dim truename1,truename2,truename3,truename4,password1,password2,password3,password4
dim name1,name2,name3,name4
name1=null
name2=null
name3=null
name4=null
truename1=trim(request.Form("truename1"))
truename2=trim(request.Form("truename2"))
truename3=trim(request.Form("truename3"))
truename4=trim(request.Form("truename4"))
password1=trim(request.Form("password1"))
password2=trim(request.Form("password2"))
password3=trim(request.Form("password3"))
password4=trim(request.Form("password4"))
set rs=server.createobject("adodb.recordset")
sql="select * from user"
rs.open sql,conn,1,1
do while not rs.eof
if trim(rs("truename")=trim(truename1) then
call checkpassword1
end if
if trim(rs("truename")=trim(truename2) then
call checkpassword2
end if
if trim(rs("truename")=trim(truename3) then
call checkpassword3
end if
if trim(rs("truename")=trim(truename4) then
call checkpassword4
end if
rs.movenext
loop
jilu
set rs=nothing
sub checkpassword1()
if trim(rs("jiaojie"))=trim(password1) then
name1=truename1
end if
end sub
sub checkpassword2()
if trim(rs("jiaojie"))=trim(password2) then
name2=truename2
end if
end sub
sub checkpassword3()
if trim(rs("jiaojie"))=trim(password3) then
name3=truename3
end if
end sub
sub checkpassword4()
if trim(rs("jiaojie"))=trim(password4) then
name4=truename4
end if
end sub
sub jilu
set rs1=server.createobject("adodb.recordset")
sql1="select * from djjbantime where (id is null)"
rs1.open sql1,conn,1,3
rs1.addnew
dim mtime
mtime=now()
rs1("truename1")=name1
rs1("truename2")=name2
rs1("truename3")=name3
rs1("truename4")=name4
rs1("endtime")=cdate(mtime)
rs1.update
end sub
%>