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> </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语句错误