Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Multiselects and the trimming function

Help
Tim Gaul
2009-11-16
2013-04-22
  • Tim Gaul
    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