Str=", 2," Sql="select * from DsNews where NS_ShowPage Like '%"& Str &"%'" ........
我都说了,不用Like ,有没有别的方法!?
Str=", 2," Sql="select * from DsNews where NS_ShowPage Like '%"& Str &"%'"
大哥,你们都 从来不看上面的回贴的吗,我说了不用like!
sql="select * from DsNews" rs.open sql,conn,1 do until rs,eof if Instr(""&rs("NS_ShowPage")&"",", 2,")<>0 then ’这里写提取处理 end if rs.movenext loop rs.close
Str=", 2,"Sql="select * from DsNews where charindex(NS_ShowPage,'%"& Str &"%')>0"
Sql="select * from DsNews where NS_ShowPage Like '%"& Str &"%'"
........
Sql="select * from DsNews where NS_ShowPage Like '%"& Str &"%'"
rs.open sql,conn,1
do until rs,eof
if Instr(""&rs("NS_ShowPage")&"",", 2,")<>0 then
’这里写提取处理
end if
rs.movenext
loop
rs.close
where charindex(NS_ShowPage,'%"& Str &"%')>0"