Hotspot link; Works in R5, doesn't work in R6

I used to have a piece of text on the home page of my R5 server saying “Check my mail”. This was set as a hotspot link with a computer URL behind it:

filename:=@ReplaceSubstring(@DbLookup(“”:“NoCahce”;“”:“names.nsf”;“($Users)”;@UserName;“Mailfile”);“\”;“/”);“/”+@If(@LowerCase(@Right(filename;4)) =“.nsf”;filename;filename+“.nsf”)

When they click the link, it opened their mail file. Simple.

Doesn’t work on my ND6 server and I can’t figure out why. Is there another way to do it?

Thanks,

Steve

Subject: Hotspot link; Works in R5, doesn’t work in R6

Let’s see if I understand what you were doing … maybe you’re just resolving on the file path/name in particular with this formula:

filename:=@ReplaceSubstring(@DbLookup(“”:“NoCache”;“”:“names.nsf”;“($Users)”;@UserName;“Mailfile”);“\”;“/”);

@If(@LowerCase(@Right(filename;4)) =“.nsf”;filename;filename+“.nsf”);

In this case, you’re running the formula “locally” on the server, too, right? Is this in a Web app or something?

You may want to append “?OpenDatabase” to this if it’s a URL. I’m not sure how strict ND6 is here.

It may be a good idea to check whether the resulting filename “looks good”, too. If your users were kept back on R5-structured mail DBs, it’s possible the file name is “.ns5” now.