<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Pass parameters to an URL of a data connection (SOLVED)</title><link>https://www.infopathdev.com:443/forums/thread/84155.aspx</link><pubDate>Mon, 05 Nov 2012 16:17:24 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:84155</guid><dc:creator>saurabh.dasgupta</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/84155.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=84155</wfw:commentRss><description>This snippet worked for me. I did not have to use ActiveXObject(&amp;quot;Microsoft.XMLHTTP&amp;quot;) and run into issues of Access Denied. 

	var accountNumber=XDocument.DOM.selectSingleNode(&amp;quot;//my:myFields/my:DistributorDetails/my:AccountNumber&amp;quot;).text
	var url=&amp;quot;http://sharepoint.myserver.com/sites/accounts/Shared%20Documents/views/queryAccNumDuplicates.aspx?acc=&amp;quot; + accountNumber;
	
	var xmlAdapter=XDocument.DataAdapters[&amp;quot;QueryDuplicateACCNUM&amp;quot;]
	xmlAdapter.FileURL=url;
	xmlAdapter.Query();
	var dataObj  =XDocument.DataObjects(&amp;quot;QueryDuplicateACCNUM&amp;quot;);
	var response=dataObj.DOM.xml;</description></item><item><title>Pass parameters to an URL of a data connection</title><link>https://www.infopathdev.com:443/forums/thread/84097.aspx</link><pubDate>Thu, 01 Nov 2012 16:05:53 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:84097</guid><dc:creator>saurabh.dasgupta</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/84097.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=84097</wfw:commentRss><description>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(&amp;quot;Microsoft.XMLHTTP&amp;quot;);
	xhttp.open(&amp;quot;GET&amp;quot;,url,false);
	xhttp.send();
	var response=xhttp.responseText;

But, here is the challenge - the above code will throw an &amp;#39;Access Denied&amp;#39; error on the second line, when configured with Full Trust. If I switch to &amp;#39;Automatically determine security&amp;#39; 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</description></item></channel></rss>