Code <% Response.ContentType ="text/html" Response.Charset ="UTF-8" set conn = Server.CreateObject("Adodb.Connection") conn.ConnectionString="Provider=SQLOLEDB; Data Source=192.168.1.20;UID=sa; PWD=123456; Initial Catalog=turbocms_6008;" conn.Open
Sql_str="SELECT id,keyword FROM cms_content where keyword like '%"& request.QueryString("q") &"%'" set rs=server.createobject("adodb.recordset") rs.open Sql_str,conn,1,3