说我这句有语法错误,从IF request那开始,大家帮忙看下

来源:百度知道 编辑:UC知道 时间:2024/05/21 17:19:03
<select name="txtKMB" size="1" style="width:150px">
<option value="" selected>---</option>
<%
set rs=server.createobject("adodb.recordset")
sql="select MONEYITEM2 from MONEYITEM2"
If Request.QueryString("a") = "kmbKeyWord" And
Trim(Request.QueryString("kws")) <> "" then
sql = sql & " where MONEYITEM2 like
'%"&Trim(Request.QueryString("kws"))&"%'"
End If
rs.open sql,conn,1,1
for i=0 to rs.recordcount-1
%>
<option
value="<%=rs("MONEYITEM2").value%>"><%=rs("MONEYITEM2").value%></option>
<%
rs.movenext
next
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</select></td></tr>

If Request.QueryString("a") = "kmbKeyWord" And
Trim(Request.QueryString("kws")) <> "" then

不要换行

If Request.QueryString("a") = "kmbKeyWord" And Trim(Request.QueryString("kws")) <> "" then

下面的sql一样,

你这样的IF条件,很可能造成SQL字符串为空