28,409
社区成员




Microsoft VBScript 运行时错误 错误 '800a000d'
类型不匹配: 'listpages'
/sys_admin/Gbook_List.asp,行 119
<!--#include file="check_session.asp"-->
<!--#include file="../inc/function.asp"-->
<%
if mod_power("L1")=false then
call error_out("您没有此项目管理权限!")
end if
action=request.querystring("action")
if action="" then
action="view"
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="style/css1.css" rel="stylesheet" type="text/css">
<SCRIPT language=JavaScript type=text/JavaScript>
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function ConfirmDel()
{
if(confirm("真得要删除吗?"))
{
return true;
}
else
{
return false;
}
}
//-->
</SCRIPT>
<script src="../js/news_del.js"></script>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" class="tableborder1">
<tr class="trhead1">
<td>位置:在线留言管理</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<%
select case action
case "view" %>
<form name="ck" method="post" action="?action=del">
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder1">
<tr class="trhead1">
<td width="5%" height="25"><div align="center">选择</div></td>
<td width="13%" height="25"><div align="center">昵称</div></td>
<td width="33%" height="25"><div align="center">标题</div></td>
<td width="13%" height="25"><div align="center">IP地址</div></td>
<td width="15%" height="25"> <div align="center">留言时间</div></td>
<td width="10%" align="center">回复状态</td>
<td width="11%" height="25"> <div align="center">操作</div></td>
</tr>
<%
intPageSize=10
strPageUrl="guestbook.asp?1=1"
SQLSelect="select C_Name,I_GbookID,C_Title,DT_AddDate,C_IP,C_Reply from TB_WebGbook"
SQLWhere=" where 1=1"
SQLOrder=" order by I_GbookID desc"
SQLTable=trim(mid(SQLSelect,(instr(SQLSelect,"from")+4)))
SQL1="select count(*) from TB_WebGbook"&SQLWhere
intRecordCount=conn.execute(SQL1)(0)
call PageCute(intRecordCount,intPageSize)
SQL=SQLSelect&SQLWhere&SQLOrder
set rs=conn.execute(SQL)
if not rs.eof then
rs.move (CurrentPage-1)*intPageSize
for i=1 to intPageSize
%>
<tr bgcolor="#FFFFFF">
<td height="25" align="center"> <input name="news_id" type="checkbox" id="news_id" value="<%= rs("I_GbookID") %>" >
</td>
<td height="25"><%= rs("C_Name") %> </td>
<td height="25"><%= rs("C_Title") %></td>
<td height="25"><%= rs("C_IP") %></td>
<td height="25" align="center"><%= rs("DT_AddDate") %></td>
<td align="center">
<%if rs("C_Reply")<>"" then:response.Write("<font color=blue>已回复</font>"):else response.write("<font color=red>未回复</font>")%>
</td>
<td height="25"> <div align="center"> <a href="?action=ShowContent&id=<%= rs("I_GbookID") %>">回复</a>
</div></td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
else
response.write "<tr bgcolor='#FFFFFF'><td colspan=7 align=center><font color='#FF0000'>暂无记录</font></td></tr>"
end if
%>
<tr bgcolor="#FFFFFF">
<td height="25" colspan="7"><div align="right">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="16%"><font color="#FF0000">
<input type="checkbox" name="checkbox" id="checkAll" onclick="checkall()">
<font color="#FF0000"><strong>全选</strong></font>
<input type="submit" name="Submit" value="删除" class="button1" onclick="return ConfirmDel();">
</font> </td>
<td width="84%">
<%listpages rs,mycondition
rs.close
set rs=nothing%>
</td>
</tr>
</table>
</div></td>
</tr>
</table>
</form>
<%
case "ShowContent"
Id=CheckID(request("Id"))
set rs=conn.execute("select * from TB_WebGbook where I_GbookID="&clng(id))
if rs.eof or rs.bof then
call error_out("数据已删除。")
else
%>
<form name="form1" method="post" action="?action=save">
<table width="98%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#0099CC">
<tr>
<td width="13" rowspan="12" align="center" bgcolor="#0099CC"><b>在<br>
<br>
线<br>
<br>
留<br>
<br>
言</b> </td>
<td colspan="2" align="left" bgcolor="#FFFFFF"><font color="#0000FF">->留言内容</font></td>
</tr>
<tr>
<td width="100" align="center" bgcolor="#FFFFFF">网友昵称:</td>
<td width="780" bgcolor="#FFFFFF"><%=rs("C_Name")%></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">标 题:</td>
<td bgcolor="#FFFFFF"><%=rs("C_Title")%></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">电子邮件:</td>
<td bgcolor="#FFFFFF"><a href="mailto:<%=rs("C_Email")%>"><%=rs("C_Email")%></a> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">留言内容:</td>
<td bgcolor="#FFFFFF"> <%=rs("C_Content")%></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">留言时间:</td>
<td bgcolor="#FFFFFF"><%=rs("DT_AddDate")%> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">IP地址:</td>
<td bgcolor="#FFFFFF"><%=rs("C_IP")%></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#FFFFFF"><font color="#0000FF">->回复区</font></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">回复内容:</td>
<td bgcolor="#FFFFFF"><textarea name="C_Reply" cols="50" rows="10" id="C_Reply"><% if id<>"" then response.write rs("C_Reply") %></textarea>
* </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">回复时间:</td>
<td bgcolor="#FFFFFF"> <% if id<>"" then response.write rs("DT_ReplyDate") %> <input name="id" type="hidden" id="id" value="<%= rs("I_GbookID") %>"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><input name="Submit22" type="submit" class="button1" value="回 复">
<input name="Submit2" type="button" class="button1" onClick="javascript:history.back();" value="返 回"></td>
</tr>
</table>
</form>
<%
rs.close
set rs=nothing
end if
case "save"
id=request("id")
C_Reply=request.Form("C_Reply")
if C_Reply="" then
call error_out("请填写回复内容。")
end if
'response.Write "|"&scid&"|"&check&"|"'&request.Form("content")&"|"
sql="select * from TB_WebGbook where I_GbookID="&id
set rs=mod_rs(sql)
if rs.eof then
call error_out("找不到此文件,可能已经被其他人删除。")
end if
rs("C_Reply")=C_Reply
rs("DT_ReplyDate")=now()
rs.update
rs.close
set rs=nothing
response.redirect("Gbook_list.asp")
case "del"
Id=request.Form("news_id")
if Id="" then
call error_out("请选择留言!")
end if
conn.execute("delete from TB_WebGbook where I_GbookID in ("&Id&")")
conn.close
set conn=nothing
response.Redirect("Gbook_list.asp")
end select %>
<p> </p>
</body>
</html>
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]列名 'id' 无效。
/sys_admin/AD_List.asp,行 96