<% @ 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");
// Special characters: ,%, &, = ,?, etc. Transfer solution. Client character is Escape encoded
// So the server side must pass the UNESCAPE decoding.
// Update: 2004-6-1 12:22
Var SQL = "Select SortName from Article_Sort Order by Order";
VAR RS = Oconn.execute (SQL);
While (! rs.eof)
{
// UNESCAPE solves the problem of Chinese processing.
Response.write (Unescape ("sortname"). Value "
"));
rs.movenext ();
}
%>
Transfer from:
http://goaler.xicp.net/showlog.asp?id=490