4 Replies Latest reply: May 18, 2012 2:28 AM by Anosh Nathaniel RSS

    (Isnull) (Replace) and (hyperlink)



      Could anyone please help that what is it not right with following ??? I want to hyperlink these all these images to its appropriate paths in internal source and on wesite too. Is it possible ?


      if (IsNull (PATH='http://www.mywebsite.com/images/PriceList/defaultLH.jpg'),


      if (WildMatch(PATH,'\\sql_rep\ImageVault\*'),'http://www.mywesite.com/images/PriceList/') & Replace(WildMatch(PATH,'\\sql_rep\ImageVault\*'),'',


      if (WildMatch(PATH,'V:\*'),'http://www.mywebsite.com/images/PriceList/') & Replace(WildMatch(PATH,'V:\*'), '',


      if (WildMatch(PATH,'\\SQL_REP\IMAGEVAULT*'),'http://www.mywebsite.com/images/PriceList/*') & Replace(WildMatch(PATH,'\\SQL_REP\IMAGEVAULT*'), ''))))

      AS NEW;



      May anyone help me with that ?

      Many thanks