Forum Stats

  • 3,838,514 Users
  • 2,262,378 Discussions
  • 7,900,678 Comments

Discussions

Select List / Drop down not working correctly

Brian666H
Brian666H Member Posts: 33 Red Ribbon

I have a drop down / select list of months.

SELECT MONTHCD val, TO_CHAR(TO_DATE(MONTHCD, 'MM'), 'MON') label

FROM [email protected]

where YEAR_FROM = NVL(:P2_YEAR, NVL(:P2_YEARFROM, YEAR_FROM))

GROUP BY MONTHCD;

The list shows the VAL not the Label.  

All examples show it in this order and I have other list on another page where the label is show. 

I have no idea why it’s  doing this.

I’ve changed it around thinking that was why the value was not getting passed but that didn’t fix it either.

Looking for suggestions

Thanks

 

Tagged: