28,391
社区成员
发帖
与我相关
我的任务
分享后台论坛又出错了！！！！！！！！！！！
后台论坛主题删除不了，我已经勾选了复选框了，但点删除按扭时，它还在提示“请选择要删除的贴子”
discusslist.asp
<script language="javascript">
function DiscussWin(url) {
var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
oth = oth+",width=400,height=300";
var DiscussWin = window.open(url,"DiscussWin",oth);
DiscussWin.focus();
return false;
}
function SelectChk()
{
var s = false; //用来记录是否存在被选中的复选框
var Discussid, n=0;
var strid, strurl;
var nn = self.document.all.item("Discuss"); //返回复选框Discuss的数量
for (j=0; j<nn.length; j++) {
if (self.document.all.item("Discuss",j).checked) {
n = n + 1;
s = true;
Discussid=self.document.all.item("Discuss",j).id+""; //转换为字符串
//生成要删除公告编号的列表
if(n==1) {
strid = Discussid;
}
else {
strid = strid + "," + Discussid;
}
}
}
strurl = "discussdel.asp?ContId=" + strid;
if(!s) {
alert("请选择要删除的帖子!");
return false;
}
if (confirm("你确定要删除这些帖子吗？")) {
form1.action = strurl;
form1.submit();
}
}
function sltAll()
{
var nn = self.document.form1.Discuss;
for(j=0;j<nn.length;j++)
{
nn[j].checked = true;
}
}
function sltNull()
{
var nn = self.document.form1.Discuss;
for(j=0;j<nn.length;j++)
{
nn[j].checked = false;
}
}
</script>
复选框代码
<tr>
<td align="center"><%=varNo%></td>
<td align="center"><a href="view.asp?ContId=<%=rs("ContId")%>" onClick="return DiscussWin(this.href)"><%=rs("Subject")%></a></td>
<td align="center"><%=rs("UserName")%></td>
<td align="center"><%=rs("CreateTime")%></td>
<td align="center"><input type="checkbox" name="Discuss" id="<%=rs("ContId")%>" style="font-size: 9pt"value="0"></td>
</tr>
discussdel.asp
<body>
<%
'从数据库中批量删除贴子信息
Dim ContId,sql
'读取要删除的贴子编号
ContId = Request.QueryString("ContId")
sql = "DELETE FROM Content WHERE ContId In (" & ContId & ")"
'Response.Write(sql)
con.Execute(sql)
' Response.Write "<h2>成功删除!</h2>"
%>
</body>
求高手解答
discusslist.asp
<script language="javascript">
function DiscussWin(url) {
var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
oth = oth+",width=400,height=300";
var DiscussWin = window.open(url,"DiscussWin",oth);
DiscussWin.focus();
return false;
}
function SelectChk()
{
var s = false; //用来记录是否存在被选中的复选框
var Discussid, n=0;
var strid, strurl;
var nn = self.document.all.item("Discuss"); //返回复选框Discuss的数量
for (j=0; j<nn.length; j++) {
if (self.document.all.item("Discuss",j).checked) {
n = n + 1;
s = true;
Discussid=self.document.all.item("Discuss",j).id+""; //转换为字符串
//生成要删除公告编号的列表
if(n==1) {
strid = Discussid;
}
else {
strid = strid + "," + Discussid;
}
}
}
strurl = "discussdel.asp?ContId=" + strid;
if(!s) {
alert("请选择要删除的帖子!");
return false;
}
if (confirm("你确定要删除这些帖子吗？")) {
form1.action = strurl;
form1.submit();
}
}
function sltAll()
{
var nn = self.document.form1.Discuss;
for(j=0;j<nn.length;j++)
{
nn[j].checked = true;
}
}
function sltNull()
{
var nn = self.document.form1.Discuss;
for(j=0;j<nn.length;j++)
{
nn[j].checked = false;
}
}
</script>
复选框代码
<tr>
<td align="center"><%=varNo%></td>
<td align="center"><a href="view.asp?ContId=<%=rs("ContId")%>" onClick="return DiscussWin(this.href)"><%=rs("Subject")%></a></td>
<td align="center"><%=rs("UserName")%></td>
<td align="center"><%=rs("CreateTime")%></td>
<td align="center"><input type="checkbox" name="Discuss" id="<%=rs("ContId")%>" style="font-size: 9pt"value="0"></td>
</tr>
discussdel.asp
<body>
<%
'从数据库中批量删除贴子信息
Dim ContId,sql
'读取要删除的贴子编号
ContId = Request.QueryString("ContId")
sql = "DELETE FROM Content WHERE ContId In (" & ContId & ")"
'Response.Write(sql)
con.Execute(sql)
' Response.Write "<h2>成功删除!</h2>"
%>
</body>
求高手解答
...全文
请发表友善的回复…
发表回复
艾思软件-app开发公司 2010-03-23
- 打赏
- 举报
JS部分错误,应该还没到ASP的部分.但是你贴的代码我看着头痛
truejimpro 2010-03-19
- 打赏
- 举报
急，救高手
truejimpro 2010-03-19
- 打赏
- 举报
各位高手帮帮忙
truejimpro 2010-03-19
- 打赏
- 举报
discusslist.asp下半部份
<form name="form1" method="POST" >
<p>
<%
'设置SQL语句，查询表discuss中的公告信息，读取到rs对象中
Set rs = Server.CreateObject("ADODB.RecordSet")
ssql="select * From Content Order By LastAnswerTime Desc"
'set rs=con.execute(ssql)
'Dim n '用来保存记录数量
rs.Open ssql,con,3,1
'如果rs为空，则显示提示信息
If rs.eof Then
%>
<tr><td colspan=5 align="center">
<%
Response.Write "目前还没有帖子"
%>
</td></tr></table>
<%
Else
rs.pagesize=10
dim page,i
page = CLng(Request.QueryString("page"))
If page < 1 Then
page = 1
End If
If page > rs.PageCount Then
page = rs.PageCount
End If
rs.absolutepage=page
%>
</p>
<p align="center" class="STYLE1">论坛管理</p>
<p align="right" class="STYLE2">当前页码：<%=page%>/<%=rs.PageCount%></p>
<table align=center border="1" cellspacing="0" width="100%" bordercolorlight="#4DA6FF" bordercolordark="#ECF5FF" style='FONT-SIZE: 9pt'>
<tr>
<td width="6%" align="center" bgcolor="#BEDCFA"><strong>编号</strong></td>
<td width="30%" align="center" bgcolor="#BEDCFA"><strong>主题</strong></td>
<td width="24%" align="center" bgcolor="#BEDCFA"><strong>作者</strong></td>
<td width="30%" align="center" bgcolor="#BEDCFA"><strong>时间</strong></td>
<td width="10%" align="center" bgcolor="#BEDCFA"><strong>选择</strong></td>
</tr>
<%
For i = 1 To rs.PageSize
varNo = (page - 1) * rs.PageSize + i
'在表格中显示字段值
%>
<tr>
<td align="center"><%=varNo%></td>
<td align="center"><a href="view.asp?ContId=<%=rs("ContId")%>" onClick="return DiscussWin(this.href)"><%=rs("Subject")%></a></td>
<td align="center"><%=rs("UserName")%></td>
<td align="center"><%=rs("CreateTime")%></td>
<td align="center"><input type="checkbox" name="Discuss" id="<%=rs("ContId")%>" style="font-size: 9pt"value="0"></td>
</tr>
<%
rs.MoveNext
'如果已经到达记录集结尾，则退出循环
If rs.EOF Then Exit For
Next
%>
</table>
<%
'设置“第一页”链接
If page = 1 Then
'Response.Write("首页 ")
Else
Response.Write("<a href=discusslist.asp?page=1>首页</a> ")
End If
'设置“上一页”链接
If page = 1 Then
'Response.Write(" 上一页 ")
Else
Response.Write(" <a href=discusslist.asp?page=" & page-1 & ">上一页</a> ")
End If
'设置“下一页”链接
If page = rs.PageCount Then
'Response.Write(" 下一页 ")
Else
Response.Write(" <a href=discusslist.asp?page=" & page+1 & ">下一页</a> ")
End If
'设置“最后一页”链接
If page = rs.PageCount Then
'Response.Write(" 尾页 ")
Else
Response.Write(" <a href=discusslist.asp?page=" & rs.PageCount &">尾页</a> ")
End If
end if
%>
</p>
<p align="center">
<input type="button" value="添加新帖" onclick="DiscussWin('newart.asp')" name="add" />
<input type="button" value="全 选" onclick="sltAll()" name="button1" />
<input type="button" value="清 空" onclick="sltNull()" name="button2" />
<input type="submit" value="删 除" name="tijiao" onclick="SelectChk()" />
<br />
<br />
<input type="hidden" name="Discuss" />
</p>
</form>
<form name="form1" method="POST" >
<p>
<%
'设置SQL语句，查询表discuss中的公告信息，读取到rs对象中
Set rs = Server.CreateObject("ADODB.RecordSet")
ssql="select * From Content Order By LastAnswerTime Desc"
'set rs=con.execute(ssql)
'Dim n '用来保存记录数量
rs.Open ssql,con,3,1
'如果rs为空，则显示提示信息
If rs.eof Then
%>
<tr><td colspan=5 align="center">
<%
Response.Write "目前还没有帖子"
%>
</td></tr></table>
<%
Else
rs.pagesize=10
dim page,i
page = CLng(Request.QueryString("page"))
If page < 1 Then
page = 1
End If
If page > rs.PageCount Then
page = rs.PageCount
End If
rs.absolutepage=page
%>
</p>
<p align="center" class="STYLE1">论坛管理</p>
<p align="right" class="STYLE2">当前页码：<%=page%>/<%=rs.PageCount%></p>
<table align=center border="1" cellspacing="0" width="100%" bordercolorlight="#4DA6FF" bordercolordark="#ECF5FF" style='FONT-SIZE: 9pt'>
<tr>
<td width="6%" align="center" bgcolor="#BEDCFA"><strong>编号</strong></td>
<td width="30%" align="center" bgcolor="#BEDCFA"><strong>主题</strong></td>
<td width="24%" align="center" bgcolor="#BEDCFA"><strong>作者</strong></td>
<td width="30%" align="center" bgcolor="#BEDCFA"><strong>时间</strong></td>
<td width="10%" align="center" bgcolor="#BEDCFA"><strong>选择</strong></td>
</tr>
<%
For i = 1 To rs.PageSize
varNo = (page - 1) * rs.PageSize + i
'在表格中显示字段值
%>
<tr>
<td align="center"><%=varNo%></td>
<td align="center"><a href="view.asp?ContId=<%=rs("ContId")%>" onClick="return DiscussWin(this.href)"><%=rs("Subject")%></a></td>
<td align="center"><%=rs("UserName")%></td>
<td align="center"><%=rs("CreateTime")%></td>
<td align="center"><input type="checkbox" name="Discuss" id="<%=rs("ContId")%>" style="font-size: 9pt"value="0"></td>
</tr>
<%
rs.MoveNext
'如果已经到达记录集结尾，则退出循环
If rs.EOF Then Exit For
Next
%>
</table>
<%
'设置“第一页”链接
If page = 1 Then
'Response.Write("首页 ")
Else
Response.Write("<a href=discusslist.asp?page=1>首页</a> ")
End If
'设置“上一页”链接
If page = 1 Then
'Response.Write(" 上一页 ")
Else
Response.Write(" <a href=discusslist.asp?page=" & page-1 & ">上一页</a> ")
End If
'设置“下一页”链接
If page = rs.PageCount Then
'Response.Write(" 下一页 ")
Else
Response.Write(" <a href=discusslist.asp?page=" & page+1 & ">下一页</a> ")
End If
'设置“最后一页”链接
If page = rs.PageCount Then
'Response.Write(" 尾页 ")
Else
Response.Write(" <a href=discusslist.asp?page=" & rs.PageCount &">尾页</a> ")
End If
end if
%>
</p>
<p align="center">
<input type="button" value="添加新帖" onclick="DiscussWin('newart.asp')" name="add" />
<input type="button" value="全 选" onclick="sltAll()" name="button1" />
<input type="button" value="清 空" onclick="sltNull()" name="button2" />
<input type="submit" value="删 除" name="tijiao" onclick="SelectChk()" />
<br />
<br />
<input type="hidden" name="Discuss" />
</p>
</form>
