ASP SQL 排序：價格從低到高去掉 DESC 關鍵字

問題代碼

sql="select * from [info] where wz='蛋糕' order by [jg] desc"

當前使用 DESC (降序/從高到低)，需求是「從底往高的排列」即**升序/從低到高**。

解決方案

方法一：移除 DESC (默認升序 ASC)

sql="select * from [info] where wz='蛋糕' order by [jg]"

SQL 標準中 ORDER BY column 默認等同於 ORDER BY column ASC。

方法二：顯式指定 ASC (可讀性更好)

sql="select * from [info] where wz='蛋糕' order by [jg] ASC"

ASP 分頁代碼優化建議

<%
' 參數安全獲取
page = CLng(Request("page") & "")
If page = 0 Then page = 1

' SQL 參數化防注入 (需 ADODB.Command)
sql = "SELECT * FROM [info] WHERE wz=? ORDER BY [jg] ASC"
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = sql
cmd.Parameters.Append cmd.CreateParameter("@wz", 200, 1, 50, "蛋糕") ' adVarChar=200
Set rs = cmd.Execute()

' 分頁設置
rs.PageSize = 40
If page > rs.PageCount Then page = rs.PageCount
If rs.PageCount > 0 Then rs.AbsolutePage = page

' 輸出
m = 0
Do While Not rs.EOF And m < rs.PageSize
    ' 輸出 rs("字段名") ...
    rs.MoveNext
    m = m + 1
Loop
%>

關鍵點總結

• DESC = 降序 (大→小)；ASC = 升序 (小→大) = 默認
• 價格從低到高 → ORDER BY price ASC 或 ORDER BY price
• ASP 經典代碼建議逐步遷移至參數化查詢，防止 SQL 注入