set rs=conn.execute("select distinct leibie from gstz order by leibie desc")

来源：百度知道编辑：UC知道时间：2024/05/25 07:02:47

id title conter bigclass leibie
标题内容小类字段类别
像 1
2
3
按1.2.3的顺序排列怎么写代码
我都试过了还不是按顺序排

set rs=conn.execute("select distinct leibie from gstz order by leibie desc")
desc是降序，你搞反了，你写成asc即为升序
一般情况下如果order by 字段,后面不加desc或asc就按asc排序的，但有时候一些异常情况，所以最后写上

set rs=conn.execute("select distinct leibie from gstz order by leibie")
去掉 desc

set rs=conn.execute("select distinct leibie from gstz order by leibie asc")

set rs=conn.execute(sql) 和 conn.execute(sql) 有什么区别啊 "Set rs=conn.Execute(SQL)"和"rs.open SQL,conn,A,B"的关闭问题 set conn=nothing Set rs=conn.Execute("select *from students where id="&id&"") 不懂asp急set rs=conn.execute(sql)这里总是缺少对象不知为何 set rs=conn.execute("select distinct leibie from gstz order by leibie desc") set rs=conn.execute(sql)出有错误，如何改？下面是全部代码 set rs=conn.execute("select * from class order by num asc") Set Rs=conn.Execute("Select * From article Order By articleid") ASP中"Set rs=conn.Execute(SQL)"和"rs.open SQL,conn,A,B"的区别