Hi all,
I have a scenario of an InfoPath 2007 form hosted on SharePoint (working in client mode). I need to download a the contents of a page from the same SharePoint site at the click of a button. The URL to this page expects a parameter the value of which which is to be supplied using a field on the form.
I am at a loss to understand how could a URL parameter be suffixed to the URL of an existing data connection. Because of this difficulty, I managed to find the following work around using JavaScript.
var xhttp=new ActiveXObject("Microsoft.XMLHTTP");
xhttp.open("GET",url,false);
xhttp.send();
var response=xhttp.responseText;
But, here is the challenge - the above code will throw an 'Access Denied' error on the second line, when configured with Full Trust. If I switch to 'Automatically determine security' then the JS works beautifully, but I get an annoying warning popup when using a SQL data connection on the same form. The form is signed.
Any suggestions.
Many thanks,
Saurabh