Coldfusion List Help

Discussion in 'Programming' started by 3plains, Mar 25, 2008.

0
  1. #1
    I need a little help on a ColdFusion problem I am having. How would I take a comma delimited list from a database field and output the data (in any order) with a lookup table as shown below? Any help would be appreciated.

    List:
    TILFL,WASHE,SECUR,SPRNK

    Lookup Table (lookup table has many values):
    SAUNA = Sauna
    SECUR = Security System
    SPRNK = Sprinkler System
    TENNI = Tennis Courts
    TILFL = Tiled Floor
    WASHE = Washer/Dryer

    Output:
    Tiled Floor, Washer/Dryer, Security System, Sprinkler System
     
    3plains, Mar 25, 2008 IP
  2. 3plains

    3plains Well-Known Member

    Messages:
    45
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    108
    #2
    Nevermind with the question. I ended up using replacelist() function and that solved it.
     
    3plains, Mar 25, 2008 IP