Recommended: A fuzzy query syntax that is faster than like clauses Generally speaking, when using fuzzy queries, everyone will think of LIKE select * from table where a like '%character%' If multiple like fuzzy queries are used in a SQL statement and the number of records is large, the speed will definitely be very slow. The following two methods can also implement fuzzy query: select * from table where patindex('%character%',a)0 sele
The InstrRev function starts from the last search of the string, and is the preceding string.
<% Dim strTXT,pos strTXT=www.webjx.com pos=instrRev(strTXT,.) Response.Write pos %> |
The beginning of our search is in reverse order, from a point before com. The length of the starting character, including this point, has ten characters in total, and the result returned will be 9.
Through this principle, we can obtain file name, domain name suffix name, etc.
| <% Dim aa,bb,cc,dd aa=Request.Servervariables(url) bb=InstrRev(aa,/) cc=len(aa) dd=Right(aa,cc-bb) Response.Write dd %> |
Share: The current record set does not support update. This may be a limitation of the provider or a selected lock The solution is as follows: rs.cursorlocation = 3 rs.open sql,conn,1,3