Skip to Main Content

Select List / Drop down not working correctly

Brian666HJul 1 2022

I have a drop down / select list of months.
SELECT MONTHCD val, TO_CHAR(TO_DATE(MONTHCD, 'MM'), 'MON') label
FROM PS_AP_MTCH_EXP_DTL@FINRPT
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

Comments
Post Details
Added on Jul 1 2022
0 comments
2 views