至少一个参数没有被指定值。
做了个多条件查询,但提交后报错:
至少一个参数没有被指定值。
/NewAsp/Order722/order_list.asp, 第 73 行
程序中相应代码如下:
<%
dim tiaojian,keyword
NewNoe=trim(request( "NewNoe "))
if NewNoe= "1 " then
tiaojian=request( "tiaojian ")
keyword=request( "keyword ")
end if
......
select case tiaojian
case " "
strsql= "select * from [order] where userid= "&session( "userID ")& " "
case "dep "
strsql= "select * from [order] where dep= "& keyword & " "
case "who "
strsql= "select * from [order] where who= "& keyword & " "
case "desiger "
strsql= "select * from [order] where desiger= "& keyword & " "
case "company "
strsql= "select * from [order] where company= "& keyword & " "
end select
'response.Write(strsql)
' response.End()
objrs.open strsql,conn,1,1 '----73行====
%>
我用response.write检验了一下,参数是可以传过来的,但还是报错说至少一个参数没有被指定值!请问哪里有问题呢?
[解决办法]
[个人意见，仅供参考]
如果字段中有字符串，别忘了加单引号：
例如,假如company 是字符串形式的字段，应该如下操作。
strsql= "select * from [order] where company= ' "& keyword & " ' "
