日期:2014-05-17  浏览次数:20803 次

HTTP 500 求指点,在线等
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn.asp" -->
<%
set rs=server.createobject("adodb.recordset")
sql="select num,name,data,content, from content order by num desc"
rs.open sql,conn,1,1
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>content</title>
</head>

<body>
<table width="493" height="158" border="1" align="center">
  <tr>
  <td><p><%=rs("name")%><br />
  </p>
  <p></p></td>
  <td><p><%=rs("data")%><br />
  </p>
  <p></p></td>
  </tr>
  <tr>
  <td>内容</td>
  <td><p><%=rs("content")%><br />
  </p>
  <p></p></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>


------解决方案--------------------
sql="select num,name,data,content, from content order by num desc"
rs.open sql,conn,1,1
改成

sql="select * from content order by num desc"
Set rs = conn.Execute(sql)

你的sql语句错误