数据库打开,字符串问题
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<%
session("table_name")=request.QueryString("table_name")
if Request("submit")<>"" then
dim rs
set rs=Server.CreateObject("ADODB.RECORDSET")
with rs
.open session("table_name"),session("conn"),2,2,adcmdtable
.find "name = '"&request("name")&"'"
if .eof then
.addnew
.fields("name")=request("name")
.update
Response.Write("已成功添加"&request("name"))
.close
set rs=nothing
else
Response.Write(request("name")&"已存在")
end if
end with
end if
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<h2>新增
<%
if session("table_name")="department" then %>部门
<%else %>物品
<%end if%></h2>
<form action="add_department.asp" method="post" >
<TABLE>
<TR>
<TD><%
if session("table_name")="department" then %>部门
<%else %>物品
<%end if%>名称<%=session("table_name")%></TD>
<TD><INPUT TYPE="text" NAME="name"></TD>
</TR>
<TR>
<TD><INPUT TYPE="submit" name="submit" value="确认"></TD>
<TD><INPUT TYPE="button" value=" 返回" onclick="window.close()">
</TR>
<TR>
<TD></TD>
<TD></TD>
</TR>
</TABLE>
</form>
</body>
</html>
其中 .open session("table_name"),session("conn"),2,2,adcmdtable //(session("table_name")中为上一页面传来的字符串表名,经测试传来的字符串无误)出错
改为 .open "department"session("conn"),2,2,adcmdtable //(department为表名)则运行正常
请高手指点一下,我想让该页面重用,我的用法很奇怪吗?