SQL into XML

[Damjan]

Hi All;

My SQL queries return one, two, sometimes even three levels of XML
data.
So for orders in my system I would like to see in my XML:

<RESULTS>
<order>
<number>3213</number>
<date>Feb 03, 2003</date>
<product>
<name>NEC Monitor</name>
<quantity>3</quantity>
<serial_numbers >
<sn>12321312321 </sn>
<sn>44314133422 </sn>
<sn>43434343553 </sn>
<serial_numbers >
</product>
<product>
<name>Genius Mouse</name>
<quantity>2</quantity>
<serial_numbers >
<sn>23232</sn>
<sn>44343</sn>
<serial_numbers >
</product>
</order>
<order>
<number>444</number>
<date>Mar 06, 2003</date>
<product>
<name>MS Keyboard</name>
<quantity>1</quantity>
<serial_numbers >
<sn>333333</sn>
<serial_numbers >
</product>
</order>
.........
</RESULTS>

obviously my query would reutrn

order_num order_date product_name quantity
serial_number
------------------------------------------------------------------------
3231 Feb 03, 2003 NEC Monitor 3 12321312321
3231 Feb 03, 2003 NEC Monitor 3 44314133422
3231 Feb 03, 2003 NEC Monitor 3 43434343553
3231 Feb 03, 2003 Genius Mouse 2 23232
3231 Feb 03, 2003 Genius Mouse 2 44343
444 Mar 06, 2003 MS Keyboard 1 333333

You get the point. I do not want to have 3 queries, but only one that
returns something like described above.

For now I have a functioin that does this, but the algorithm is not
the best, and it only works for two levels (so XML without the s/n for
example).
This must be a common problem, I would appriciate input as to how this
is commonly done, any pointers to web sites, articles... are all
welcome. I'd try to search the groups but for what?:) I would also
like to describe my current algorithm, but for now it seems I would
just bore you.

Looking for some input

Damjan

[Attila Feher]

Re: SQL into XML

Damjan wrote:[color=blue]
> Hi All;
>
> My SQL queries return one, two, sometimes even three levels of XML
> data.[/color]

Please read the name of this newsgroup for yourself and observe that neither
XML nor SQL is in it.

--
Attila aka WW

[Damjan]

Re: SQL into XML

Not gonna argue, but how do you think youre gonna get SQL into XML
unless you use a programming language like C++.

anyway bye

[WW]

Re: SQL into XML

Damjan wrote:[color=blue]
> Not gonna argue, but how do you think youre gonna get SQL into XML
> unless you use a programming language like C++.[/color]

PHP, Perl, Java and all the million others. BTW in any case: this is not a
C++ language question. if you want to know how to make XML: post no an XML
group. If you want to know how to use SQL: post to an SQL newsgroup. If
you want to know how to make tyhe algoritm: post to an algorithm newsgroup.
If you have questions about the C++ *language*, you post here.

--
WW aka Attila