[高分求解]ASP+Sybase的问题

[youngsheep]

'open.asp和search.asp代码如下：
'open.asp

<%
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName = "shoes_test"
SqlPassword = ""
SqlUsername = "sa"
SqlLocalName = "ap03"
Set con=Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=Sybase ASE OLE DB Provider; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
con.open ConnStr
'response.write connstr
%>

' ----------------------------------------------------------------
'search.asp
<%
SQL = "select c.pbc_hdr,b.colid, b.name,b.type,b.length from sysobjects a left join syscolumns b on a.id = b.id left join pbcatcol c on (convert(varchar(10),b.id) + b.name) = (convert(varchar(20),c.pbc_tid) + c.pbc_cnam)where a.name = 'bas_item_pur'"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open SQL,con,1,1
rsCount = rs.recordcount
for x = 1 to rsCount
response.write rs("pbc_hdr") & " | " & rs("colid") & " | " & rs("name") & " | " & rs("type") & " | " & rs("length")&"<br/>"

'rs.movenext
rs.MovePrevious
next

%>

问题：
在读数据的时候response.write rs("pbc_hdr") .....，数据的记录是倒置的？ 我用了rs.movefirst也不行，都是从最后一个开始读，如果用了rs.movenext，那么就会出错(EOF)，如果用rs.MovePrevious方法，那么数据从最后一个往前读，好奇怪啊，有人知道为什么吗？ 如果知道，给个解决的方法最好了。

[sy_binbin]

是不是排序啊!

用order by id desc降序排列
用order by id asc升序排列

[cqq]

没有用过sybase，帮你顶

[youngsheep]

我在PB Sql查詢的時候,列表是正向的
反正不管怎麼排, 數據的指針總是到最後一個.. 超級郁悶....

[youngsheep]

UP

[wawowawoo]

帮顶

[wawowawoo]

帮顶