<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
%>
怎样让他读取到数据库的降序ID呢
也就是让所有文章标题最新的始终在最前面
试试看
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"
读出结果按 d_classid 字段降序排列...
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by d_classid desc"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
%>
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"
dao!
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by d_classid desc "
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
%>
上面的方法都可以，试试吧
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"
我的網頁代碼為ASP語言,驗證方式為系統自帶的WINDOW驗證模式.
現在我如果要在ASP代碼中獲取當前的登入人 ......
由于对页面使用了伪静态
并且对ID进行了加密。
主要代码如下：
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]
程序代码
A为加密，B为解密函数
<a href=&q ......
