请帮忙解决一下,谢谢!
我不知道怎么进行判断:我的程序代码如下:<%
dim Conn
dim sConn
dim RS
dim sRS
dim username,userpwd
username = TRIM(Request.Form("username"))
userpwd = TRIM(Request.Form("userpwd"))
set Conn = server.createObject("ADODB.CONNECTION")
set RS = server.createObject("ADODB.RECORDSET")
Conn.open "DSN=htwt;uid=appuser;pwd=now918"
sRS = "select * from onlineuser where username='" & username & "' and userpwd = '" & userpwd & "'"
RS.OPEN sRS,Conn,1,3
if RS.RecordCount >0 then
Session("username") = username
RS.Close
Conn.Close
set RS = Nothing
set Conn = Nothing
if Session("panduan") = "a" then
Response.redirect "../PAGE/MAIN.asp?frmSearch=duiC"
else
Session("panduan") = "b"
Response.redirect "../PAGE/MAIN0.asp?frmSearch=duiC"
end if
else
Session("username") = ""
RS.Close
Conn.Close
set RS = Nothing
set Conn = Nothing
end if
%>
就是怎么判断当用户名相对应的字段(panduan)为a是打开MAIN.asp?frmSearch=duiC为b是打开MAIN0.asp?frmSearch=duiC,谢谢?