Post reply

Add a photo link if the photo exists

  • May 4, 2011 at 5:56 am

    #239547

    Currently I am builiding a photo link based on some static information and field information,

    i.e. photoLink = "\\server\gearimages\" & partNo & "\" & machineNo & "\" & serialNo & ".jpg"

    Problem is if the photo does not exist for one reason or another then the link is useless.

    How do I confirm the photo exists and then add the link to the table?

    I was thinking some how in a script task or a for each loop?

    Thanks.

  • May 4, 2011 at 6:28 am

    #1319689

    That's going to be slow if there are a lot of records, but a loop will work well enough.

    Have you thought about modifying the software which is displaying the link to perform the check at run time instead?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply