Question

ASP 查询页面查询条件是多字段的代码?

高手们帮看看
查询页面,关键字myKeyword模糊查询ZZ字段,我要再想可以同时查询ZZ和XM2个字段应该怎么改?
if not (myKeyword = "" or IsEmpty(myKeyword) ) then
strSQL = strSQL &" AND zz like '%" & myKeyword & "%'"
end if
strSQL = strSQL & " ORDER by xh"

Answer 1

strSQL = strSQL &" AND (zz like '%" & myKeyword & "%'" or xm2 like '%"&myKeyword&"%')"
去试试

Answer 2

if not (myKeyword = "" or IsEmpty(myKeyword) ) then
strSQL = strSQL &" AND zz like '%" & myKeyword & "%'" &" AND XM2 like '%" & myKeyword & "%'"
end if
strSQL = strSQL & " ORDER by xh"