Question

asp中如何查询某个备注类字段包含指定字符串?

access数据库
表table1
字段class 备注性,格式如 "10,23,27,45"
整型变量IntClass

select * from [table1] where class like "&IntClass&"
这样查询的话,不太准确.因为当IntClass=2的时候,应该查询不到才对,这样的写查询因为23里面也包含2,导致条件成立了

Answer 1

rs.open "select * from [table1]",conn,1,1
arr=split(rs("class"),",")
rs.close
for each value in arr
sql="select * from [table1] where class="&value
rs.open sql,conn,1,1
if rs.eof then
response.write "无数据"
else
response.write "有数据"
end if
next