Any hint? Corrupted web link, HELP!

I have 4 hotspot links on a picture with 4 tabs, each tab is linking to a document depending on the UNID from a lookup view, se the code in each hotspot

UNID := @DbLookup(“”;“”:“”; “lookupView”; lookupCriteria ; 2);

@If( UNID != “” ; @URLOpen(@WebDbName +“/ LookdocId /” + UNID+ “?OpenDocument”) ; “”)

The problem is that this working very well sometimes but sometimes the link get wrong, I tried to check if the lookup not working, but everything looks fine.

I tested and the link look like this when it works fine

http://server/databesensf/LookdocId/703B1DB42937A619C12573780047D8AF?OpenDocument

When it’s not work, I don’t know why, the link looks like the following and I get error on opening the page

http://server/databese.nsf/LookdocId/703b1db42937a619c12573780047d8af?OpenDocument&Click=C12572F7002624F5.f686dd9e9a1784c4c12572c6004cf1ac/$Body/0.72C

Can any one explain to me why the link extends with this ?

&Click=C12572F7002624F5.f686dd9e9a1784c4c12572c6004cf1ac/$Body/0.72C

I searched the forum and the web and looked at _doClick but no help

Some one wrote that “the problem was corruption in “Use JavaScript when generating pages” - database property. I turned off the setting and turned it back on and the hotspot and agent work fine.”

I tried this but it did not work.

Please help me solve this! My application is going under if this will not work…

Is there any way to make this function stable and reliable?

I appreciate any hint!

Sara

Subject: Corrupted web link, HELP!!

Without having read your post in full detail - please forgive me - please rewrite your @UrlOpen formula form

@URLOpen(@WebDbName +“/ LookdocId /” + UNID+ “?OpenDocument”)

to

@URLOpen(“/” + @WebDbName +“/ LookdocId /” + UNID+ “?OpenDocument”)

Subject: RE: Corrupted web link, HELP!!

thanks, but it did’nt work

Subject: RE: Corrupted web link, HELP!!

I’m in a pretty relaxed mood today, and hope so are you.

If you have 4 hotspots on one graphic, the only available options are named element, link and URL. In no case should you use @UrlOpen in any of these, especially not in url hotspots.

Instead, you should just provide the plain URL itself, like:

UNID := @DbLookup(“” ;“”; “lookupView”; lookupCriteria ; 2);

@If(

UNID != “” ;

“/” + @WebDbName + “/ LookdocId /” + UNID+ “?OpenDocument”);

“”

)

The one drawback is, that you cannot stop a link from being created, even if your formula returns “”. One way around it would be to return “#” instead of “” in this case. This would still create a link, but to the page itself.

If this is not acceptable, cut the image into its 4 parts, mark every image and create a separate action hotspot. This will require @UrlOpen again.