股价图示

[bigluckyfox]

问一个问题：我现在做一个股价图示，用直立的进度条表示股价的变化，客户需求：股价从左到右按日期排序，旧的在前，新的在后，我使用select top 10 from stock order by adddate这样的查询语句，结果遇到麻烦,显示的是最初输入的那十条，而不是倒数的十条，请问该怎么解决呢？如果用Order by desc 但是客户不接受这样的排列方式的啊，这个是股价图示，逆向排列不符合逻辑哦

[mjpclab]

select top 10 * from (select top 10 * from stock order by adddate DESC) order by adddate

[mjpclab]

select * from (select top 10 * from stock order by adddate DESC) order by adddate

[ghy412]

up

[QQgenie]

'//用数组方式最好
<!--#include file="conn.asp"-->
<%
sql="select top 10 from stock order by adddate"
set rs=conn.execute(sql)

aResults = rs.GetRows '//取得数据集一次,以后处理速度提高

rs.close
set rs=nothing
%>
<%
iRows = UBound(aResults, 2) '//记录数

For i = iRows To 0 Step -1 '//倒取数据
response.write aResults(1,i)&" " '//最高
response.write aResults(2,i)&" " '//收盘
'//............................
'调用VML画图
Next
%>
<%
Function plot(h,c,o,l)
'//画图
'//..............
End Function
%>