When use text type parameters in LogiXML, we have to make sure the parameter values are compliant with the URL standards since LogiXML use the post back on the webpage to send the parameter values.
The following web page shows what characters should be encoded when passing through URL:
http://www.blooberry.com/indexdot/html/topics/urlencoding.htm
There are several ways to go around this problem:
1. Encode and decode the text at the SQL script since we only use these values to refresh the charts on dashboards.
SQL functions to encode and decode URL strings:
http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-urlencode.aspx
http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-urldecode.aspx
2. Use JavaScript to encode and decode the text before and after the post back.
The following web page shows what characters should be encoded when passing through URL:
http://www.blooberry.com/indexdot/html/topics/urlencoding.htm
There are several ways to go around this problem:
1. Encode and decode the text at the SQL script since we only use these values to refresh the charts on dashboards.
SQL functions to encode and decode URL strings:
http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-urlencode.aspx
http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-urldecode.aspx
2. Use JavaScript to encode and decode the text before and after the post back.
