一聚教程网:一个值得你收藏的教程网站

最新下载

热门教程

google 探索提示效果

时间:2008-06-01 编辑:简简单单 来源:一聚教程网

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
response.Charset="utf-8"
sGsName=unescape(trim(request.Form("sGsName")))
dbpath="demo.mdb"
sqlStr="select top 5 sgName from cominfo where sgName like '%"&sGsName&"%'"
connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(dbPath)
set conn=server.CreateObject("adodb.connection")
conn.open connstr
set rs=conn.execute(sqlStr)
if not rs.bof and not rs.eof then
do while not rs.eof
str=str&""&rs("sgName")&""
rs.movenext
loop
else
str="没有此公司"
end if
rs.close
set rs=nothing
set conn=nothing
response.Write(escape(str))
%>

热门栏目