URL parameters containing an apostrophe are ignored

Hi there!

I have this javascript hotspot action formula:

onclick=‘javascript:window.location.href="ItemSortOrderingDisplayListsForm?OpenForm&count=5000&RestrictToCategory=" + @URLEncode(“Domino”;List[i]) + ""’

It works well except when the RestrictToCategory parameter contains an apostrophe. Nothing happens at all when the parameter contains an apostrophe.

Any ideas?

Gérald

Subject: OpenForm and…

Shouldn’t it say “?openview”? Have you tried using an Action Hotspot containing a @URLOpen() formula?

Subject: URL parameters containing an apostrophe are ignored.

@urlEncode converts these characters: @#$%^&+{},./<>?|`"

to these Hex values:

%40, %23, %24, %25, %5E, %26, %2B, %7B, %7D, %5B, %5D, %2C., %2F, %3C, %3E, %3F, %7C, %60, %22

and doesn’t convert ~!*()_’

So the get these other characters to convert, you have to manually turn them into Hex code this way AFTER you do the @urlEncode:

@ReplaceSubstring(@AttachmentNames; @Char(34):@Char(39);“%22”:“%27”)

To get the ascii for a character hold down the Alt + 1-2-3_digit number will give you the ascii character.

Here’s the final code:

@ReplaceSubstring(@URLEncode(“Domino”;List[i]) ;@Char(34):@Char(39);“%22”:“%27”))

Sean