墨鱼与鱿鱼有什么区别:Order By '"&de&"' DESC,sunxuid"
来源:百度文库 编辑:高考问答 时间:2024/07/05 10:19:04
Function shownews(typeid,typenm,top,de)
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open "Select top "&top&" * from [ninenews] Where typeid="&typeid&" OR typename='"&typenm&"' Order By '"&de&"' DESC,sunxuid",Conn,1,1
if rs.eof and rs.bof then
response.write "<table width=100% border=0 align=Center cellpadding=0 cellspacing=0><tr><td height=20></td></tr><tr><td align=center>"
response.write "<font color=red>"&"暂无内容"&"</font>"
response.write "</td></tr></table>"
end if
Do while NOT rs.Eof
%>
<TABLE width="100%" border="0" align="Center" cellpadding="0" cellspacing="0">
<TR>
<TD width="10" Valign=top align=right>·</TD>
<TD><a title="<%=DatetoStr(rs("dateandtime"),"Y-m-d")%>" href="fen/news.asp?id=<%=rs("newsid")%>" target="_blank"><%=cutstr(rs("title"),10)%></a></TD>
</TR>
<TR>
<TD colspan=2 height=10 Valign=top align=right></TD>
</TR>
</TABLE>
<%
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
End Function
为什么用这个函数做出来的排顺是不正常的呢!~~~~
Order By '"&de&"' DESC,sunxuid"
这句是什么意思呢?
能不能说的在详细一些啊,还有就是排出来的顺序不是降顺出来的,而是反的.
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open "Select top "&top&" * from [ninenews] Where typeid="&typeid&" OR typename='"&typenm&"' Order By '"&de&"' DESC,sunxuid",Conn,1,1
if rs.eof and rs.bof then
response.write "<table width=100% border=0 align=Center cellpadding=0 cellspacing=0><tr><td height=20></td></tr><tr><td align=center>"
response.write "<font color=red>"&"暂无内容"&"</font>"
response.write "</td></tr></table>"
end if
Do while NOT rs.Eof
%>
<TABLE width="100%" border="0" align="Center" cellpadding="0" cellspacing="0">
<TR>
<TD width="10" Valign=top align=right>·</TD>
<TD><a title="<%=DatetoStr(rs("dateandtime"),"Y-m-d")%>" href="fen/news.asp?id=<%=rs("newsid")%>" target="_blank"><%=cutstr(rs("title"),10)%></a></TD>
</TR>
<TR>
<TD colspan=2 height=10 Valign=top align=right></TD>
</TR>
</TABLE>
<%
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
End Function
为什么用这个函数做出来的排顺是不正常的呢!~~~~
Order By '"&de&"' DESC,sunxuid"
这句是什么意思呢?
能不能说的在详细一些啊,还有就是排出来的顺序不是降顺出来的,而是反的.
按照 de的值所在的字段 和 sunxuid 字段进行倒序 排序
Order By '"&de&"' DESC,sunxuid"
str4="select * from yiyuan where g='1' and id=&idd order by data desc"
str4="select * from yymess where address<>'' and userid=&idd order by data desc"
sql="select * from wz order by id desc" | 无法理解?
strsql="select*from user where usern=usern order by id" 这一句哪错了???
stb="select top 1 id FROM our order by id "
asp中 sqlcp="select top 16 * from xnzj order by ArticleID desc"是什么意思
rs.open"select * from lyb order by sj DESC",conn,1,1是什么
"0 order by weight desc, selecttime desc LIMIT 40"指的是什么意思?
[asp]order by的问题