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

    (Isnull) (Replace) and (hyperlink)

      Hi,

       

      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

      Aamir