< %@Language="JavaScript " %>
1
2function OpenDB(dbname)
3{
4var connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(dbname);
5var conn = Server.CreateObject("ADODB.Connection");
6conn.Open(connstr);
7return conn;
8}
9var sResult = new Array();
10var oConn = OpenDB("Data/Data.mdb");
11//特殊字符:+,%,&,=,?等的传输解决办法.客户端字符是经过escape编码的
12//所以服务器端先要经过unescape解码.
13//Update:2004-6-1 12:22
14var sql = "select SortName From Article_Sort order by OrderID";
15var rs = oConn.Execute(sql);
16while(!rs.EOF)
17{
18//unescape解决中文处理的问题.
19Response.Write(unescape(rs("SortName").Value + "
<br/>
1"));
2rs.MoveNext();
3}