distinct 放在select语句中为何出错?谢谢!!
下面的代码:
<!--#include file="./function/DBOpen.asp"-->
<%
set rs=server.createobject("adodb.recordset") '查找显示浏览者信息
rs.open "select newsid,reviewid,rtime from news where newsid="& request("newsid"),conn
%>
在newsid,reviewid前放distinct网页就出错,不知为什么?如下:
rs.open "select distinct newsid,reviewid,rtime from news where newsid="& request("newsid"),conn