Add a photo link if the photo exists

• smac

  SSC Eights!

  Points: 855

  More actions

  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.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  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?

  ---