如何使用JavaScript來寫ASP程序
作者：Eve Cole
更新時間：2009-06-24 17:21:45
<%@Language="JavaScript" %>
<%
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();
}
%>
