==谁能帮我解决这个搜索问题,谢谢==
源代码:
company=trim(request.querystring("company"))
area=trim(request.querystring("area"))
if company="" and area="所有地区" then
sql="select * from yp"
else
if company="" and area<>"所有地区" then
sql="select * from yp where area like '%"&area&"%'"
else
if company<>"" and area="所有地区" then
sql="select * from yp where company like '%"&company&"%'"
else
if company<>"" and area<>"所有地区" then
sql="select * from yp where company like '%"&company&"%' and area like '%"&area&"%'"
end if
end if
end if
end if
rs.open sql,conn,1,2
错误提示:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
ADODB.Recordset 错误 '800a0bb9'
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突。
/searchcom.asp,行354