Subject: RE: display shared image on web problem …
I had the right idea, but the wrong culprit. You should make it:
svr := Server_Name;
db := @Subset(@DbName; -1);
@If(Department =“HR”; files := “logo1.jpg”;“”);
(“http://” +Svr + “/” + db + “/”) + files
The problem is that the @DbName is a list of two elements, the first is the server (blank in your case), the second is the filepath. So, in your instance, the two elements propogate through the list. Of course, you might be even better off using
Subject: RE: display shared image on web problem …
Among other things, you haven’t indicated that you are calling an image – the code is just creating a URL. And that URL is going to be a “stub” pointing to the database if the department is not HR. Your code should probably look something like this instead: