Computed URL Hotspot -- Simple How-to Question

Hope someone can point out what I’m doing wrong. I’m just trying to create a URL Hotspot link in document #1 that will simply open document #2 when document #1 is opened in a web browser & the hotspot is clicked. I don’t want to hard-code the “server/dbPath/nsfName” in the URL.

Test #1:

Formula:

docID := “/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”;

@WebDbName + docID

And, I get this URL:

http:////<dbName.nsf>//<dbName.nsf>/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument

Test #2:

If I change the Formula:

docID := “/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”;

@URLOpen(docID);

The URL is only:

http:////<dbName.nsf>/

Test #3:

If I change the Formula:

docID := “/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”;

@URLOpen(docID) + docID;

The URL is:

http:///xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument

Test #4:

With Formula:

docID := “/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”;

docID

I get this URL:

http:///xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument

Test #5:

With Formula:

@URLOpen(“/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”);

I get this URL:

http:////<dbName.nsf>/

Test #6:

“/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”

I get this URL:

http:///xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument

I’ve about exhausted the permutations and combinations I’m willing to try.

What on earth am I doing wrong?

Subject: First, forget about using @UrlOpen

The formula for a computed URL is supposed to return a string which is the URL. @URLOpen doesn’t return a string – it opens a URL. It’s an action function. But you don’t want to open the URL at the time you’re rendering the page. You just want to calculate the URL.

“/” at the beginning of the URL means the path is relative to the “root” of the same server. So the first thing following the initial “/” should be the database path on that server:

“/” + @WebDbName + “/xpDocumentation.xsp?documentId=B508A37198F953E285257787000626B3&action=openDocument”

Subject: Big sigh … thank-you Andre

… for your explanation & help. Worked great!