Organizing a Combo Box

[Ghost21 0]

Is there a way to sort a combo box contents.. Via numbers or letters ???

[Monamo 3]

Is there a way to sort a combo box contents.. Via numbers or letters ???

Using the GUICtrlCreateCombo() "style" parameter, $CBS_SORT

[Ghost21 0]

Using the GUICtrlCreateCombo() "style" parameter, $CBS_SORT

I thought that worked only if its being typed in... Sorry should have been more specific. It's being queried from an SQL database and sent to it...

[james3mg 1]

I thought that worked only if its being typed in... Sorry should have been more specific. It's being queried from an SQL database and sent to it...

Should still work, I think.

Anyway, can't you add a Order By parameter to your sql SELECT query?

[Ghost21 0]

Should still work, I think.

Anyway, can't you add a Order By parameter to your sql SELECT query?

hmmm.. I will have to look that up...Thanks for the tip..

[Cyri 0]

hmmm.. I will have to look that up...Thanks for the tip..

I'm running into a similar situation. I'm using logparser to populate the combo box. I'm already using an Order By in the LogParser query, but it's case sensitive. The $CBS_SORT doesn't work. As stated before, that will only work for ones you type into the drop down.

Any other suggestions? I haven't been able to get Log Parser to be case insenstive when sorting.

Edited February 24, 2009 by Cyri

[Melba23 2,888]

Hi,

Why not load the returned values into an array and then sort the array (_ArraySort). Getting the array into the combo is trivial:

For $i = 1 To $aList[0]
    $sList &= $aList[$i] & "|"
Next

$hCombo = GUICtrlCreateCombo (...)
GUICtrlSetData(-1, $sList, "")

M23

[Cyri 0]

Hi,

Why not load the returned values into an array and then sort the array (_ArraySort). Getting the array into the combo is trivial:

For $i = 1 To $aList[0]
    $sList &= $aList[$i] & "|"
Next

$hCombo = GUICtrlCreateCombo (...)
GUICtrlSetData(-1, $sList, "")

M23

I was hoping to avoid that extra step, but that sounds like the way to go. Thanks.