Another Defect related to handling of URL Encoded Characters ...

Another Defect related to handling of URL Encoded Characters ...

Attention ZOHO Creator Support:

I have discovered another problem related to ZOHO Creator's handling of the URL Encoded value associated with the single quote ( ' ) character.

I have an HTML View that reads a (previously stored URL encoded) value from the logged in User's record in a Table ... and passes it as a parameter to an embedded View ... so the records in the Embedded View ONLY display records where a given field/column matches the passed value.

The part of the HTML View script that displays an embedded View of the Table entries looks like ...
<iframe height='500px' width='100%' name='zoho-Education_View' frameborder='0' scrolling='auto' src='http://creator.zoho.com/scriptedlogic/xxxx/view-embed/Education_View/jhGfDDdUhsv1J7QanhPxHZsSbSDd8YTAsXzjqOjKDytxmdwWTDDNKuJgvPyEn8sgknOFnOhbkd2qxA00QjtwN7hbPZxCPWKeYYZn/ Expert_Info=<%=Encoded_Expert_Info%>'></iframe>



... I have xxxx'ed out application name in this post to preserve privacy of customer for whom this App is being developed.


This works just fine when the value to be filtered is something like John Smith or even Mary H. Robinson ... however, when the name is something like Pietro O'Brien ... i.e. containing the single quote character ...

a) the embedded View is correctly displayed when first navigated to it.

b) but after the user adds or edits one of the displayed rows of data ... the refreshed embedded View shows up without any rows ... as if there were no matches at all ... clicking on the (FireFox) Browser's Reload Button results in all the expected records ... i.e. the one just added or edited ... as well as the other matching ones ... to be displayed properly.

Note that this incorrect (defective) behaviour is ONLY experienced when the encoded value of a single quote is contained within the value passed in the iframe tag ... and ONLY after the user submits the (popped up) form to add/edit a record.



Gaev