在asp中如何用数组将sql数据表一行的多个列的值进行排序？

来源：百度知道 编辑：UC知道 时间：2024/05/10 11:31:21
将10个数值写入sql数值表的一行中。如何用数组的方式调出该行的10个列的值进行排序，然后单独显示该行某列最大值或者最小值？？

Sql="Select top 1 * From [table]"
Set Rs=Conn.Execute(Sql)

dim ID,ArrayID,Myarray,M
ID=Rs(0)&","&Rs(1)&","&Rs(2)&","&Rs(3)&","&Rs(4)&","&Rs(5)&","&Rs(6)&","&Rs(7)&","&Rs(8)&","&Rs(9)

ArrayID=split(ID,",")
Myarray=Sort(ArrayID)
'排序测试
For M=0 To Ubound(Myarray)
Response.Write Myarray(M) & "<br>" & vbCRLF
Next

'冒泡
Function Sort(ary)
Dim KeepChecking,I,FirstValue,SecondValue
KeepChecking = TRUE
Do Until KeepChecking = FALSE
KeepChecking = FALSE
For I = 0 to UBound(ary)
If I = UBound(ary) Then Exit For
If ary(I) > ary(I+1) Then
FirstValue = ary(I)
SecondValue = ary(I+1)
ary(I) = SecondValue
ary(I+1) = FirstValue
KeepChecking = TRUE
End If
Next
Loop