[3] When I run the xquery I get (minimally formatted):
<Gainers>
<CompanyName>CONOLOG CORP TARGETED GENETICS CP MICROWAVE FILTER C</CompanyName>
<Ticker>CNLG TGEN MFCO</Ticker>
<LastTradePrice>3.68 6.30 1.55</LastTradePrice>
</Gainers>
[4] I would like to see:
<Gainers>
<CompanyName>CONOLOG CORP</CompanyName>
<CompanyName>TARGETED GENETICS CP</CompanyName>
<CompanyName>MICROWAVE FILTER C</CompanyName>
<Ticker>CNLG</Ticker>
<Ticker>TGEN</Ticker>
<Ticker>MFCO</Ticker>
<LastTradePrice>3.68</LastTradePrice>
<LastTradePrice>6.30</LastTradePrice>
<LastTradePrice>1.55</LastTradePrice>
</Gainers>
[5] Is this possible for the output?:
<Gainers>
<CompanyName>CONOLOG CORP</CompanyName>
<Ticker>CNLG</Ticker>
<LastTradePrice>3.68</LastTradePrice>
<CompanyName>TARGETED GENETICS CP</CompanyName>
<Ticker>TGEN</Ticker>
<LastTradePrice>6.30</LastTradePrice>
<CompanyName>MICROWAVE FILTER C</CompanyName>
<Ticker>MFCO</Ticker>
<LastTradePrice>1.55</LastTradePrice>
</Gainers>
Subject:I can't seem to get my xml Author:Doug Lundin Date:28 Nov 2006 07:15 AM
Ok, now I've fiddled around trying to get the data into its end-state:
<Gainers>
<CompanyName>CONOLOG CORP</CompanyName>
<Ticker>CNLG</Ticker>
<LastTradePrice>3.68</LastTradePrice>
<CompanyName>TARGETED GENETICS CP</CompanyName>
<Ticker>TGEN</Ticker>
<LastTradePrice>6.30</LastTradePrice>
<CompanyName>MICROWAVE FILTER C</CompanyName>
<Ticker>MFCO</Ticker>
<LastTradePrice>1.55</LastTradePrice>
</Gainers>