Tim Gaul - 2009-11-16

I have found since installing ApexLib 2.0 that I have been having the following issue on my multiselects (I am unsure if this affects other LOV items):

An item with an ID of 10 is returned as 1; however, when I add $APEXLIB_NO_TRIM$ to the comments the ID is returned as 10.

My LOV select is as follows:

select NAME display_value, ID return_value
from PRS_BRANCH
order by PRS_BRANCH.BRC_CODE

where ID is of number(10) in the database.

Any ideas what could be causing this because I know it isn't the Oracle trim(or r/ltrim) function?

Thanks