mtb_crm_asp/system/SearchArea.asp

<!--#include file="Conn.asp"-->
<%Checklogin("信息管理")%>
<%
str=TextEnCode(Request.QueryString("str"))

Set Rs=Server.CreateObject("Adodb.Recordset")
	sql="select id,countryCode,countryName from country where countryCode like '%"&str&"%' or countryName like '%"&str&"%' "
    Rs.open sql,conn,1,3
	Do while Not Rs.bof and Not Rs.eof
		%>
		<li data-id="<%=Rs("id")%>"><div class="list-content"><span class="code"><%=Rs("countryCode")%></span><span class="cname"><%=Rs("countryName")%></span></div></li>
		<%	
		Rs.moveNext
	loop
	Rs.close
Set Rs=Nothing
conn.close
Set conn=Nothing
%>