为什么 head, vServer,vDbf, vSql 几个变量不能传到文本框里?
bc3 2003-12-18 05:05:13 <%
Head="Table01.asp - RDS 与 TABLE 的结合"
vServer="http://" & Request.ServerVariables("Server_name")
vDbq=Server.MapPath("/source/mdb/stock01.mdb")
vSQL="Select * From 股票行情表 Where 股票代号 Like '600%'"
%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=gb_2312-80">
<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0">
<title><%=Head%></title>
</head>
<body bgcolor="#FFFFFF">
<h1><%=Head%></h1>
<hr>
<div align="center"><center>
<table border="0">
<tr>
<td align="right">Server:</td>
<td><input type="text" size="50" name="Server"
value=<%=Request.ServerVariables("Server_name")%>> </td>
</tr>
<tr>
<td align="right">数据库:</td>
<td><input type="text" size="50" name="Dbq"
value="<%=vDbq%>"> </td>
</tr>
<tr>
<td align="right">SQL:</td>
<td><input type="text" size="50" name="SQL"
value="<%=vSQL%>"> </td>
</tr>
<tr>
<td align="center" colspan="2"><input type="button"
value="打开数据库" onclick="OpenDB()"></td>
</tr>
</table>
</center></div>
<hr width="80%">
<div align="center"><center>
<table border="1" datasrc="#RDS1">
<THEAD> <tr>
<td bgcolor="#00FFFF">股票代号</td>
<td bgcolor="#00FFFF">股票名称</td>
<td bgcolor="#00FFFF">收盘价</td>
<td bgcolor="#00FFFF">涨跌</td>
<td bgcolor="#00FFFF">最高价</td>
<td bgcolor="#00FFFF">最低价</td>
<td bgcolor="#00FFFF">成交量</td>
</tr>
</THEAD><TBODY> <tr>
<td bgcolor="#FFFFFF"><DIV DataFld="股票代号"></DIV> </td>
<td bgcolor="#FFFFFF"><DIV DataFld="股票名称"> </td>
<td bgcolor="#FFFFFF"><DIV DataFld="收盘价"> </td>
<td bgcolor="#FFFFFF"><DIV DataFld="涨跌"> </td>
<td bgcolor="#FFFFFF"><DIV DataFld="最高价"> </td>
<td bgcolor="#FFFFFF"><DIV DataFld="最低价"> </td>
<td bgcolor="#FFFFFF"><DIV DataFld="成交量"> </td>
</tr>
</TBODY></table>
</center></div>
<p><object id="RDS1"
classid="ClsID:BD96C556-65A3-11D0-983A-00C04FC29E33"
align="baseline" border="0" width="50" height="50"></object></p>
<script language="VBScript">
Sub OpenDB()
RDS1.Server = Server.Value
RDS1.Connect = "driver={Microsoft Access Driver (*.mdb)}" & _
";dbq=" & Dbq.Value
RDS1.SQL = SQL.Value
RDS1.Refresh
End Sub
</script>
<hr>
</body>
</html>