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方法，那麼數據從最後一個往前讀，好奇怪啊，有人知道為什麼嗎？ 如果知道，給個解決的方法最好了。

[youngsheep]

補充：如果是rs.recordcount的問題，那麼我在rs.recordcount後面加一個movefirst，那記錄的指針仍然不能指向第一筆

[issgates]

ASP接触不多，有工具的话调试一下就知道原因了。帮顶一下。

[youngsheep]

up

[youngsheep]

再UP