印字胶带分切:ASP老手再来帮帮忙哇

来源：百度文库编辑：高考问答时间：2024/04/16 17:48:49

刚刚改完又出这个错了
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/admin_addfun.asp，行 47

下面是源码帮偶改好哇#47

<title>添加论坛分类</title>
<style type="text/css">

</style>
<body>
<form action="admin_addfun.asp" method="post">
<%
if session("admin")="" then
response.Write("请先登录")
else
%>
</form>
</p>
<p class="STYLE3">添加论坛版块：</p>
<table width="325" border="1">
<tr>
<td width="126" height="29"><strong>输入版块名称</strong></td>
<td width="183"><label>
<input name="areaname" type="text" id="areaname" />
</label></td>
</tr>
<tr>
<td height="31" colspan="2"><label>
<span class="STYLE2">
<input type="submit" name="Submit" value="提交" />
<input type="reset" name="Submit2" value="重设" />
</span></label></td>
</tr>
</table>
<%
dim conn
dim strconn
set conn=server.CreateObject ("adodb.connection")
strconn="driver={sql server};server=(local);database=mydb;uid=sa;pwd="
conn.Open strconn
%>
<%
areaname=request.Form("areaname")
set rs1=server.CreateObject("adodb.recordset")'读数据库
rs1.open ("select * from area where areaname='"&areaname&"' order by id desc"),conn,1,1
if(not rs1.eof)then
Response.Write("名称‘"&areaname&"’已经存在！")
else
conn.execute"insert into users (areaname)values('"&areaname&"')"'插入数据库
set rs=server.CreateObject("adodb.recordset")'读数据库
rs.open ("select * from area order by id desc"),conn,1,1
response.Write("名称:"&rs("areaname")&"<br>")
rs.close
conn.close
end if
end if
%>
</body>

谢谢了

rs1.open ("select * from area where areaname='"&areaname&"' order by id desc"),conn,1,1
看看你怎么写的

把括号去掉

rs1.open "select * from area where areaname='"&areaname&"' order by id desc",conn,1,1

rs1.open ("select * from area where areaname='"&areaname&"' order by id desc"),conn,1,1
改成
rs1.open "select * from [area] where areaname='"&areaname&"' order by id desc",conn,1,1

rs1.open "select * from area where areaname='"&areaname&"' order by id desc",conn,1,1

rs.open "select * from area order by id desc",conn,1,1

楼主的括号怎么到处用啊！！

ASP老手再来帮帮忙哇 ASP老手来帮帮忙哇手机老手帮帮忙哈`` 希望攒机老手。帮帮忙电脑高手再来帮帮忙咯热血江湖老手进来帮帮忙 ASP问题,老手相助拉.来看咯! 电脑老手进来帮帮忙,小弟感激不尽求对联老手帮帮忙对出下联！！！热血江湖的老手`帮帮忙啊`