fiazkhan
asked on
molding sql results in coldfusion
I am trying to list a group of results by category in sql and have done by using 'ORDER BY category'.
I now want to display a text field from the same table alphabetically but it wont due to it being ordered by category which puts the list in category order.
How do i list the results in category order and when the categories are the same list the items by title alphabetically????....
I now want to display a text field from the same table alphabetically but it wont due to it being ordered by category which puts the list in category order.
How do i list the results in category order and when the categories are the same list the items by title alphabetically????....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
never though u could have more than one ORDER BY field...
ta!