<?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>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Populating SQL clause with node value.</title><link>https://www.infopathdev.com:443/forums/thread/58961.aspx</link><pubDate>Wed, 15 Sep 2010 19:47:49 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:58961</guid><dc:creator>cjordan</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/58961.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=58961</wfw:commentRss><description>&lt;p&gt;The other alternative to this is passing the node name to a web service via string, which might be easier. I&amp;#39;m just wondering how I would do it...&lt;/p&gt;</description></item><item><title>Populating SQL clause with node value.</title><link>https://www.infopathdev.com:443/forums/thread/58959.aspx</link><pubDate>Wed, 15 Sep 2010 19:22:56 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:58959</guid><dc:creator>cjordan</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/58959.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=58959</wfw:commentRss><description>&lt;p&gt;Hello,&lt;/p&gt;
&lt;p&gt;&amp;nbsp;Maybe someone around here can help me out...I&amp;#39;ve programmatically generated a form template from a database schema, but since it&amp;#39;s dynamic I need to be able to dynamically bind the data.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Is there a way to pass the value of the current xml node name in the Edit Sql Section of the Data Wizard? For example, say my field node is &amp;lt;my:node1234&amp;gt;...is there a way to query using the node name?&lt;/p&gt;
&lt;p&gt;&amp;nbsp;i.e.&lt;/p&gt;
&lt;p&gt;SELECT * FROM tableabc&lt;/p&gt;
&lt;p&gt;WHERE general_ID = &amp;#39;&amp;lt;my:node1234&amp;gt;&amp;#39;&lt;/p&gt;
&lt;p&gt;Any help would be much appreciated.&lt;/p&gt;</description></item></channel></rss>