Active Server Page (ASP) 常見問題[14]|中文方案文档站(提供各类方案下载,WORD文档下载,范文,案例等)

sql = sql & " like '%" & dbwhere & "%'"
end if

' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' %除錯用, 回傳 sql 敘述
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
response.write "<b><font size=2 color=blue>sql statement: </b>" &
sql & "<hr>"

' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % 開啟 recordset (rs) 乲傳到
' % connection (conn) 和 sql 敘述 (sql)
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
rs.open sql, conn
%>

<p>
<table border=1>
<tr>
<%
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % 迴圈從 fields names ，印出 field names
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

for i = 0 to rs.fields.count - 1
%>
<td><b><% = rs(i).name %></b></td>
<% next %>
</tr>
<%
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % 迴圈從 rows, 顯示每一個field
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
do while not rs.eof
%>
<tr>
<% for i = 0 to rs.fields.count - 1 %>
<td valign=top><% = rs(i) %></td>
<% next %>
</tr>
<%
rs.movenext
loop
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
' % 確誮阷閉 result set 以及 connection object
' %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
rs.close
conn.close
%>
</table>

<%
end if
end if
%>

問：要如何使用 active server pages 程式頰防瀏覽器開啟檔案時只顯示為frameset的一部份？答：當web 文件變成frameset的一部份的情形發生，通常是由於不是詏計成個別顯示，要頰防這個情形，可使用asp 的"response.redirect" 和 "request.servervariables" 方重新指向到frameset page。

假詏使用以下文件架構:

frameset page (mainfrm.htm)
frame 1 (frame1.asp)
frame 2 (frame2.asp)

將以下的程式碼放在frame1.asp 或是 frame2.asp 在開頭的<html> tag 之前

<%
if (request.servervariables("http_referer") = "") or _
(left(request.servervariables("http_referer"),42) <> _
"http://www.myserver.com/appdir/mainfrm.htm") then
response.redirect "http://www.myserver.com/appdir/mainfrm.htm"
end if
%>

以下是這個例子的程式碼

file: mainfrm.htm
-----------------

<html>

Active Server Page (ASP) 常見問題[14]

[入库：2005年8月18日] [更新：2007年3月24日]