留言本中记录的删除.还没有解决.
代码如下:他说我第5句有问题.checkbox.是复选框的名字,用来选中将被删除的记录每个复选框的属性值是这条记录在数据库中的序号seq.. seq是数值型的.
pplication.Lock()
for i=1 to request.form("checkbox").count
num=request.form("checkbox")(i)
set conn=server.CreateObject("adodb.connection")
conn.open"dsn=dd;uid=11;pwd=11"
sqlstr="delete from guest where seq='"&num"'"
set rs=conn.execute(sqlstr)
rs.close
counter=counter+1
next
application.UnLock()%>
问题点数：0、回复次数：4Top
1 楼xfekin（随缘而逝）回复于 2003-08-03 09:59:26 得分 0
SQL="Delete From Guest Where seq In ("&Request.Form("checkbox")&")"
Conn.Execute(SQL)Top
2 楼onekey（星星离我还很远）回复于 2003-08-03 10:05:19 得分 0
sqlstr="delete from guest where seq="&num
数值型的不用加引号
Top
3 楼zorou_fatal（The world and system is even）回复于 2003-08-03 10:09:07 得分 0
set rs=conn.execute(sqlstr)
直接conn.execute(sqlstr)
就可以了。不需要返回给一个对象。Top
4 楼dgm8（dgm8）回复于 2003-08-03 10:13:03 得分 0
for i=1 to request.form("checkbox").count
num=request.form("checkbox")(i)
set conn=server.CreateObject("adodb.connection")
conn.open"dsn=dd","11","11"
sqlstr="delete from guest where seq="&num
set rs=conn.execute(sqlstr)
rs.close
counter=counter+1
nextTop
