I was looking at the page:
The /products_partial_match/ page already had an ORDER BY in the Recordset. The sort will append to the Order By statement in that case and add to the end of it. It won't replace or override it so that the Recordset order by will have precedence. The solution is to add the order by that you had in the Recordset as the Default order by in the sort server behavior, which I've done.
The page is working properly now.