Auto Arrange an ASP dropdown list

How to

[5stars]

I have a product dropdown list that my designer set up to arrange by product ID. When we entered all our products they were entered in alphabetical order and the product ID was issued with an auto number.

Recently I have added some products and they no longer fall in alphabetical order. Is there something I can add to the current code to make the name sort A to Z

The current code is:

<% Call setCombos("cbo_PID_" & iCnt, "", 1, "All Driving States", "SELECT productID, name FROM tb_Product WHERE catType=2", con) %>

Thanks in advanced for your help.

[Mosha]

i'm not a hundred percent on this but try this in replacement of ur code:

<% Call setCombos("cbo_PID_" & iCnt, "", 1, "All Driving States", "SELECT productID, name FROM tb_Product WHERE catType=2 ORDER BY name", con) %>

Where the new code is on BOLD

Hope this helps

[5stars]

That worked like a dream.

1000 thank yous.

J