Skip navigation
btvbillb
btvbillb
Currently Being Moderated

How to get CF to read file names from a folder and display?

Aug 8, 2012 10:07 AM

I have a folder with images and I'd like to have the image names displayed in a table, next to a corresponding customer number (which is pulled from a database) or if no image exists, then a noimage.jpg would disply as default. Can I do this in ColdFusion without having to reference image names from a database, etc.? For now, the images are just sitting in a folder. If so what code would I need to use? Thanks.

496 Views   9 Replies   Latest reply: btvbillb, Aug 8, 2012 12:37 PM
 
Replies
  • WolfShade
    Currently Being Moderated
    1. WolfShade,
    Aug 8, 2012 10:17 AM   in reply to btvbillb
    Report

    If the image names are not in the database, how would the image be associated with the customer?  Is the image filename the customer name or id?

     

    ^_^

     
    |
    Mark as:
  • btvbillb
    Currently Being Moderated
    2. btvbillb,
    Aug 8, 2012 10:25 AM   in reply to WolfShade
    Report

    Yes, its based on the customer number, ie.

    <td width="74%" align="left" valign="top"><img src="../RepInformation/images/#CustomerNumber#.png" onerror="this.src='../RepInformation/images/noImage.gif';"></td>

     
    |
    Mark as:
  • Reed Powell
    Currently Being Moderated
    3. Reed Powell,
    Aug 8, 2012 11:11 AM   in reply to btvbillb
    Report

    Are you looking for something more than what CFDIRECTORY does?

    -reed

     
    |
    Mark as:
  • WolfShade
    Currently Being Moderated
    4. WolfShade,
    Aug 8, 2012 11:23 AM   in reply to Reed Powell
    Report

    I was just going to suggest the same thing.  CFDIRECTORY (if it is turned on in CFAdmin) would be perfect. 

     

    ^_^

     
    |
    Mark as:
  • btvbillb
    Currently Being Moderated
    5. btvbillb,
    Aug 8, 2012 11:57 AM   in reply to Reed Powell
    Report

    Probably. I don't need it to just print a list of files. I need it to display each individual image file name to the right of each record. Here is a screenshot of the tabel I have to add it to. Right after Territry, I need a column with 11871.jpg, 11899.jpg, etc and then any record without an image would show "noimage.jpg". Hope this makes sense.

    Capture.PNG

     
    |
    Mark as:
  • Reed Powell
    Currently Being Moderated
    6. Reed Powell,
    Aug 8, 2012 12:11 PM   in reply to btvbillb
    Report

    Need to understand whether the database is driving the list, or are the contents of the folder driving the list.  If you are looping through a query resultset from the database, that has the customer numbers and territory info, which is what it sounds like, then what you are really asking for (I think) is whether that customer's corresponding image file exists.  In which case you want the cf function named, you guessed it - fileExsits().

     

    If on the other hand you are driving this beast from whatever is in the folder, and looking for the corresponding data in the database, then use CFDIRECTORY and parse off the customer number in order to do the SELECT against the table.  But I don't think that is the scenario you are describing.

     

    Did either of those putts make it into the cup?

    -reed

     
    |
    Mark as:
  • btvbillb
    Currently Being Moderated
    7. btvbillb,
    Aug 8, 2012 12:17 PM   in reply to Reed Powell
    Report

    Thanks Reed. Both columns pull from a database but the images are not in the database, but in a folder and are referenced only by the line of code in number 2 above.

     
    |
    Mark as:
  • Dan Bracuk
    Currently Being Moderated
    8. Dan Bracuk,
    Aug 8, 2012 12:33 PM   in reply to btvbillb
    Report

    As others have mentioned, cfdirectory will provide you with the file names.  You can query your db for other stuff and put it all together with Query of Queries.

     

    Some of the details might be tricky.  Good luck and post back if you have difficulty.

     
    |
    Mark as:
  • btvbillb
    Currently Being Moderated
    9. btvbillb,
    Aug 8, 2012 12:37 PM   in reply to Dan Bracuk
    Report

    Thanks everybody. I got it to work. Here is my code in case someone else needs help:

     

      <td>#CustomerName#</td>
      <td>#CustomerNumber#</td>
      <td><cfif FileExists("\\ncc1701-01\web\Sales\Information\images\#CustomerNumber #.png")>
            YES
        <cfelse>
            NO
        </cfif></td>
     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points