同时查询同一字段里不同的数据(只有一个查询条件框) - 编程论坛

#2

madpbpl2008-06-19 03:07

finefp=trim(request(finefp))
if instr(finefp,",") then
str =split(finefp,",")
sql ="sql ="select id,fp from table where"
for i=0 to ubound(str)
sql =sql&" and fp like '%"&str(i)&"%'"
next
sql =sql &" order by id desc"
else
sql="select id,fp from table where fp like '%"&trim(request("finefp"))&"%'"
end if
set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sql,conn,1,1
试试这样

#3

yms1232008-06-19 10:10

<input name="finefp" type="text" id="finefp"><input type="submit" name="Submit" value="查询">
  <%
  set rs=Server.CreateObject("ADODB.RecordSet")
  sql="select id,fp from table where fp in ("&trim(request("finefp"))&")"
  rs.open sql,conn,1,1
  %>
fp如果是数字就可以按上面的方法写用in操作符
比如
select id,fp form table where fp in (111,222,333,556,666)
注意
select id,fp form table where fp in (111,222,333,556,666,)
这样写是错误的因为in语句最后一个数值后面不能有,号也就是说666后面不能有,号

#4

anjincheng2008-06-19 14:32

太感谢了老师们!