Recommendation: The current recordset does not support updates. 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
Generally speaking, when using fuzzy query, 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 queries:
select * from table where patindex('%character%',a)>0
select * from table where charindex('character',a)>0
After testing, these two methods are faster than LIKE.
Share: ASP common error analysis and solutions Error message: ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. /index.asp, line 15. Error reason: The latest component of Dongyi component is installed on the server, but the website system is using 4.0 , the system did not find the corresponding field. Dong Yi Group