Recommended: How to make ASP page display recordset data 1. Create Recordset object as follows: Dim objMyRst Set objMyRst=Server.CreateObject("ADODB.Recordse
In web development, I often encounter multiple keyword pairs of single field queries, which I usually implement through dynamic arrays. Of course, multiple keywords are generally separated by spaces or,. I assume that multiple keywords are separated by spaces, the keyword string is keyStr, and the specific code is.
The program code is as follows:
The following is the quoted content:
'Keyword search
str=select * from tableName where id>4
if srhKey<> then
keyArr=split(srhKey, )
j=UBound(keyArr)
t=0
dim keystrArr()
for i=0 to j
if keyArr(i)<> then
redim preserve keystrArr(t)
strfilter=(empZw like '%&keyArr(i)&%' or empDep like '%&keyArr(i)&%' or empGz like '%
strfilter=strfilter&keyArr(i)&%' or empWy1 like '%&keyArr(i)&%' or empWy2 like '%&keyArr(i)
strfilter=strfilter&%' or empYq like '%&keyArr(i)&%' or com_name like '%&keyArr(i)&%')
keystrArr(t)=strfilter
t=t 1
end if
next
keystr=join(keystrArr, and )
str=str& and &keystr
end if
Share: parsing ASP instance: Slide news code The following is the referenced content: !--This is a home page file -->html>head>meta http-equiv=Content-Type content=