<%
' 建立 Connection 物件
page=request("page")
RESPONSE.BUFFER=ture
Set conn = Server.CreateObject("ADODB.Connection")
'Provider = "Provider=Microsoft.Jet.OLEDB.4.0;"
DBPath = Server.MapPath( "dbase/edudb.mdb" )
' 連結資料庫
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
unitlist = request("unlst")
IF unitlist = "" then unitlist = "學會/協會"
' 開啟資料來源,
sqlstr = "Select * From member where"
sqlstr = sqlstr & " unit like '" & unitlist & "' "
sqlstr = sqlstr & " Order By name DESC "
rs.Open sqlstr, conn,1,1
rs.pagesize=10
%>
<% IF PAGE = "" THEN PAGE = 1 %>
LandscapeWeb全球景觀資訊網--學術相關資源類
文獻資料
英國景觀教育與發展