Hi
I have a form with a tree on it. When the user selects a node the link part of the SQL statement runs a Javascript function which populates a hidden field with the name of the node selected. I then use the contents of the hidden field (selected node name from the tree) in a where clause to query the database for some data. This all works fine until the node name contains an ampersand (&) character and then of course doesn't work as this is a special character. I've tried lots of things and looked on lots of blogs to get round this but so far nothing. I've tried escaping the ampersand, putting it in quotes, etc but none of this seems to work. Does anybody know of a good way to solve this issue? Any help would be much appreciated.
Thanks
Will