I have an InfoPath form that uses a SmartObject update method, using a few text fields in the InfoPath form. One of the fields is for a URL, and when I put an ampersand (&) in the text field, e.g.
http://server/file.aspx?val1=x&val2=y
the ampersand gets replaced with the encoded value of & ---
http://server/file.aspx?val1=x&val2=y
Is there any way to prevent this from happening? Note I am using the Dynamic SQL Service broker (not SmartBox).