Flowgear查询XML结果

Question

我有一个SQL查询，带有一个简单的SELECT语句，用于XML AUTO元素。

这是中的一个示例文本结果：

> XML_F52E2B61-18A1-11d1-B105-00805F49916B
> -------------------------------------------------------------------------------- <row><CompanyID>0</CompanyID><Company>0  
> </Company><GlCode>00-1010</GlCode><GlYear>2009</GlYear><BeginYearBalance>0.00</BeginYearBalance><ClosingBalPer1>50251640.00</ClosingBalPer1><ClosingBalPer2>45141985.00</ClosingBalPer2><ClosingBalPer3>43603485.00</C
> lPer7><ClosingBalPer8>0.00</ClosingBalPer8><ClosingBalPer9>0.00</ClosingBalPer9><ClosingBalPer10>0.00</ClosingBalPer10><ClosingBalPer11>0.00</ClosingBalPer11><ClosingBalPer12>0.00</ClosingBalPer12><ClosingBalPer13>0.00</ClosingBalPer13><ClosingBalPer14>0.0
> BalPer1><ClosingBalPer2>20000.00</ClosingBalPer2><ClosingBalPer3>0.00</ClosingBalPer3><ClosingBalPer4>0.00</ClosingBalPer4><ClosingBalPer5>0.00</ClosingBalPer5><ClosingBalPer6>0.00</ClosingBalPer6><ClosingBalPer7>0.00</ClosingBalPer7><ClosingBalPer8>0.00</
> alPer14>

它为每个记录创建熟悉的<row>元素结构，并为每个列创建一个元素。

但是，当我在Flowgear中运行节点时，就会出现这样的情况：

<Result>
  <Table>
    <XML_F52E2B61-18A1-11d1-B105-00805F49916B>&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1010&lt;/GlCode&gt;&lt;GlYear&gt;2009&lt;/GlYear&gt;&lt;BeginYearBalance&gt;0.00&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;50251640.00&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;45141985.00&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;43603485.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;37602854.06&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;30477670.97&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;27131030.91&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;26489572.00&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;24508174.38&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;25107606.36&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;24838327.11&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;28456828.16&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;3205488.90&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;3205488.90&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;3205488.90&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1010&lt;/GlCode&gt;&lt;GlYear&gt;2010&lt;/GlYear&gt;&lt;BeginYearBalance&gt;3205488.90&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;69904850.41&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;70035845.09&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;69751854.18&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;76699659.70&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;64868593.99&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;63343067.84&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;67160186.41&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;66030723.36&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;67336905.21&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;67363017.56&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;67275039.96&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;64310025.92&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;64310025.92&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;64310025.92&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1010&lt;/GlCode&gt;&lt;GlYear&gt;2011&lt;/GlYear&gt;&lt;BeginYearBalance&gt;64310025.92&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;63333898.71&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;63334486.71&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;0.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;0.00&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;0.00&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;0.00&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;0.00&lt;/ClosingBa</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
  </Table>
  <Table>
    <XML_F52E2B61-18A1-11d1-B105-00805F49916B>lPer7&gt;&lt;ClosingBalPer8&gt;0.00&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;0.00&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;0.00&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;0.00&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;0.00&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;0.00&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;0.00&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1020&lt;/GlCode&gt;&lt;GlYear&gt;2009&lt;/GlYear&gt;&lt;BeginYearBalance&gt;0.00&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;20000.00&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;20000.00&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;20000.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;20000.00&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;20000.00&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;20000.00&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;20000.00&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;20000.00&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;20000.00&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;20000.00&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;20000.00&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;20000.00&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;20000.00&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;20000.00&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1020&lt;/GlCode&gt;&lt;GlYear&gt;2010&lt;/GlYear&gt;&lt;BeginYearBalance&gt;20000.00&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;20000.00&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;20000.00&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;20000.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;20000.00&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;20000.00&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;20000.00&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;20000.00&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;20000.00&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;20000.00&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;20000.00&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;20000.00&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;20000.00&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;20000.00&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;20000.00&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1020&lt;/GlCode&gt;&lt;GlYear&gt;2011&lt;/GlYear&gt;&lt;BeginYearBalance&gt;20000.00&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;20000.00&lt;/Closing</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
  </Table>
  <Table>
    <XML_F52E2B61-18A1-11d1-B105-00805F49916B>BalPer1&gt;&lt;ClosingBalPer2&gt;20000.00&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;0.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;0.00&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;0.00&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;0.00&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;0.00&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;0.00&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;0.00&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;0.00&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;0.00&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;0.00&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;0.00&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;0.00&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1030&lt;/GlCode&gt;&lt;GlYear&gt;2009&lt;/GlYear&gt;&lt;BeginYearBalance&gt;0.00&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;15000.00&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;30000.00&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;30000.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;30000.00&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;30000.00&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;30000.00&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;30000.00&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;30000.00&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;30000.00&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;30000.00&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;30000.00&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;30000.00&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;30000.00&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;30000.00&lt;/ClosingBalPer14&gt;&lt;ClosingBalPer15&gt;0.00&lt;/ClosingBalPer15&gt;&lt;/row&gt;&lt;row&gt;&lt;CompanyID&gt;0&lt;/CompanyID&gt;&lt;Company&gt;0   &lt;/Company&gt;&lt;GlCode&gt;00-1030&lt;/GlCode&gt;&lt;GlYear&gt;2010&lt;/GlYear&gt;&lt;BeginYearBalance&gt;30000.00&lt;/BeginYearBalance&gt;&lt;ClosingBalPer1&gt;30000.00&lt;/ClosingBalPer1&gt;&lt;ClosingBalPer2&gt;30000.00&lt;/ClosingBalPer2&gt;&lt;ClosingBalPer3&gt;30000.00&lt;/ClosingBalPer3&gt;&lt;ClosingBalPer4&gt;30000.00&lt;/ClosingBalPer4&gt;&lt;ClosingBalPer5&gt;30000.00&lt;/ClosingBalPer5&gt;&lt;ClosingBalPer6&gt;30000.00&lt;/ClosingBalPer6&gt;&lt;ClosingBalPer7&gt;30000.00&lt;/ClosingBalPer7&gt;&lt;ClosingBalPer8&gt;30000.00&lt;/ClosingBalPer8&gt;&lt;ClosingBalPer9&gt;30000.00&lt;/ClosingBalPer9&gt;&lt;ClosingBalPer10&gt;30000.00&lt;/ClosingBalPer10&gt;&lt;ClosingBalPer11&gt;30000.00&lt;/ClosingBalPer11&gt;&lt;ClosingBalPer12&gt;30000.00&lt;/ClosingBalPer12&gt;&lt;ClosingBalPer13&gt;30000.00&lt;/ClosingBalPer13&gt;&lt;ClosingBalPer14&gt;30000.00&lt;/ClosingB</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
  </Table>

节点将结果进一步分割成似乎是固定长度的<Table>元素。其中，第二个表节点包含来自第一个表元素的文本平衡。

这导致了非常不同的XML，而且我不知道如何在下一个花齿轮节点(我的XSLT转换)中处理这个看似非结构化的XML。

请help...why，这是正在发生的，我如何使它停止？

Answer 1

在使用XML查询时，需要在节点上勾选XmlQuery属性。

对于XML查询，SQL返回一个非常不同的响应，需要告诉Flowgear相应地解析它。

有关更多详细信息，请参阅Query。