Multiselects and the trimming function

Tim Gaul
  • Tim Gaul
    Tim Gaul

    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?