lordan Posted June 17, 2009 Share Posted June 17, 2009 Hi, I designed a dashboard with a master report and some input controls.One of these input controls is a single select from a sql query.The selected value is passed to a report parameter.Everythings works fine with this input control unless the selected value contains a '&' - as far as i brought light to it.In such a case the passed value is NULL.What did I miss or is there any workaround to mask special characters?Thanks in advance. Harald Link to comment Share on other sites More sharing options...
shrije Posted June 18, 2009 Share Posted June 18, 2009 Try escaping the character & and othetr characters like #, @ with a \. For example replace '&' with '\&'. Link to comment Share on other sites More sharing options...
lordan Posted June 18, 2009 Author Share Posted June 18, 2009 I can not manipulate the data in the database.So my only chance would be to escape the characters after the query before passing via URL.How can I escape it in the input control ?Just with some Java code in the setting of the value (input control details -> value and visible columns)? regards,Harald Link to comment Share on other sites More sharing options...
lordan Posted June 18, 2009 Author Share Posted June 18, 2009 CLOSE :-) I fixed it with a replace in the input control query and a "back-replace" in the parameter.it works - I am happy.Thx for the assistance Harald Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now