来源:关于asp使用textarea批量查询数据库的问题-CSDN社区
dim CPN,CPNs
CPN=request.querystring("CPN1") '来自form标里的 name="CPN1" , 这只是一个查询条件
CPN=replace(CPN,vbtab,chr(13)&chr(10))
CPN=replace(CPN,";",chr(13)&chr(10))
CPN=replace(CPN,";",chr(13)&chr(10))
CPN=replace(CPN,"/",chr(13)&chr(10))
CPN=replace(CPN," ",chr(13)&chr(10))
CPNs=split(CPN,chr(13)&chr(10))
for i=0 to ubound(CPN)
if i=0 then sql2=" where R3PN like '"&CPN(i)&"'"
sql2= sql2 & " or R3PN like '"&CPN(i)&"'"
next
sql="Select * from [bw] " & sql2
最终得到的的sql2为什么会有换行符? 以导致最终查询结果不对 >>已解决
where R3PN like 'AC60001SJ5L' or R3PN like 'AC60001SJ5L' or R3PN like '
AC60001SJGL' or R3PN like '
AC60001X55L' or R3PN like '
AC600023Z1L' or R3PN like '
' or R3PN like '