5 Replies Latest reply on Oct 22, 2007 8:19 AM by Mush15

    The word "null" is concatenated during string concatenation.

    aceinc Level 1
      In a grid in an Item renderer in a list I am concatenating some data from an arrayColletcion like so;

      <mx:List id="lstResHistory" x="0" y="64" width="518" height="275"
      paddingBottom="0" paddingLeft="0" paddingRight="0"
      paddingTop="0" variableRowHeight="true">
      <mx:Grid x="0" label="grdResHistoryDetail" borderStyle="solid"
      horizontalGap="0" verticalGap="0" borderThickness="1" paddingLeft="0" paddingRight="0"
      horizontalScrollPolicy="off" paddingTop="0" paddingBottom="0" dropShadowEnabled="false"
      <mx:GridItem width="205" height="100%" borderStyle="solid" borderThickness="1"
      <mx:Text width="205" text="{data.VENDOR_NAME + '\n' + data.VENDOR_ADDRESS_1 + '\n' + data.VENDOR_ADDRESS_2 + '\n' + data.VENDOR_ADDRESS_3}" truncateToFit="true"/>

      This works well, except if one (or more) of the fields is null in the database, I get the word "null" in the grid.

      I tried to nvl the data with a " " (space), but I get the same results. If I nvl (nvl is similar to coalesce for sql server folks) with a printable character it works fine.

      Anybody run into this before? How did you resolve it?