Recommended: How to generate html pages for asp dynamic pages There are many news systems for generating html, but they all use templates. This function saves the html code generated by the asp page into an html file, so there is no need to change the original page to easily complete the news that generates html system
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.
Program code:
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: Brief analysis of ASP AJAX search tips similar to Google The main files are: Index.html implementation function, a text box, input content and implement the prompt search.asp query function, let the content entered in the text box be queried in the database, and then return it to the client conn.asp database connection function, implement the and