剛寫的應用於某軟體的全文檢索索引程式

<p> <!--#include file=function/conn.asp-->
<br>
<%
keyWord=trim(request("oKey"))
sType=trim(request("oType"))
if keyWord="" or keyWord="關鍵字…" then
Response.Write "請輸入關鍵字！"
Response.End()
end if
if sType="" then
Response.Write "請選取查詢資訊類別"
Response.End()
end if
dim ftsTable '要查詢資訊的儲存表名
dim ftsFolder '要查詢資訊的儲存檔案夾　
if sType="1" then
ftsTable="tb_bzxx"
ftsFolder=fjroot
elseif sType="2" then
ftsTable="tb_other"
ftsFolder=fjroot_other
elseif sType="3" then
ftsTable="tb_info"
ftsFolder=fjroot_info
else
Response.Write "出錯了！"
Response.End
end if
sql=""
if sType="1" then
sql="select bz_xuhao as xuhao,bz_name as bname,bz_code as bcode,bz_htm as htm from " & ftsTable
elseif sType="2" then
sql="select p_xuhao as xuhao,p_name as bname,p_code as bcode,p_htm as htm from " & ftsTable
elseif sType="3" then
sql="select info_id as xuhao,info_htm,info_type as htm from " & ftsTable
else
Response.Write "出錯了！"
Response.End
end if
Call OPenConn() ' 開啟資料庫連接
set fso=server.CreateObject("scripting.filesystemobject")
set rs=server.createobject("adodb.recordset")
dim oPattern
oPattern="<p>|<p(.*)>|</p>"
'如果是查詢第三種資訊（其他資訊），則先將所有的資訊類別取出來，放到數組中。
dim infoType()
if sType="3" then
rs.Open "select type_id,type_name from tb_info_type order by type_id desc",adocon,3,1
if rs.RecordCount<=0 then
CloseRs rs
Call CloseConn
Response.Write "出錯了！"