<%@Language="javaScr<% function OpenDB(dbname) { var connstr = "PRovider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(dbname); var conn = Server.CreateObject("ADODB.Connection"); conn.Open(connstr); return conn; } var sResult = new Array(); var oConn = OpenDB("Data/Data.mdb"); //特殊字符：+,%,&,=,?等的傳輸解決辦法.客戶端字符是經過escape編碼的 //所以服務器端先要經過unescape解碼. //Update:2004-6-1 12:22 var sql = "select SortName From Article_Sort order by OrderID"; var rs = oConn.Execute(sql); while(!rs.EOF) { //unescape解決中文處理的問題. Response.Write(unescape(rs("SortName").Value + "<BR>")); rs.MoveNext(); } %>
