急，急，急，简单的问题

[momocat]

set jianjie=lj.execute("select jianjie from huiyuan where mingzi='" & server.HTMLEncode(mingzi) & "' ")
if jianjie=1 then
response.redirect "1.asp"
elseif jianjie=2 then
response.redirect "2.asp"
elseif jianjie=3 then
Response.Redirect "3.asp"

end if

运行后出错Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft VBScript 运行时错误 错误 '800a000d'

类型不匹配

/oa/b_look.asp，行10

我的huiyuan表里jianjie数据项是数值型

[QQgenie]

为什么要把简单的事情复杂化呢？

没少END IF

set rs=lj.execute("select jianjie from huiyuan where mingzi='" & server.HTMLEncode(mingzi) & "' ")
jianjie = rs("jianjie") '用这个取出jianjie再判断吧
if jianjie=1 then
response.redirect "1.asp"
elseif jianjie=2 then
response.redirect "2.asp"
elseif jianjie=3 then
Response.Redirect "3.asp"

end if

[pj0643]

1、检查sql语句中的where语句mingzi的值是字符还是数字，字符型才用‘’
2、如果返回值是字符在if语句中使用="1"

[wdyxt]

jianjie的类型是什么呀
if jianjie="1" then 这样试试

[aoenzh]

if jianjie=1 then
response.redirect "1.asp"
end if
if jianjie=2 then
response.redirect "2.asp"
end if
if jianjie=3 then
Response.Redirect "3.asp"
end if
这样试试看

[huhanshan013]

jianjie=1 是什么东西啊？

好象是
jianjie（"jianjie"）=1

这样吧？

[momocat]

jianjie是数值型，原来是文本型的jianjie="1"也出同样的错误

[skyboy0720]

jianjie（"jianjie"）=.xxxx

[diveas]

set jianjie=lj.execute("select jianjie from huiyuan where mingzi='" & server.HTMLEncode(mingzi) & "' ")
if jianjie=1 then
response.redirect "1.asp"
elseif jianjie=2 then
response.redirect "2.asp"
elseif jianjie=3 then
Response.Redirect "3.asp"

End If
End If
end if

[diveas]

你少了2个 End If