I need some xsql/xslt/xml help.

Factual Questions
1

I hate to post this here but I posted it on some forums dedicated to this stuff and got no help. I also tried google but I don’t really know what to google for.

Scenario: User will select several ‘styles’. From these styles, I want to return information about each. To over simplify it, here is an example, (in xml):

<Style 1>
-<UPC A>
</Style>
<Style 2>
-<UPC B>
-<UPC C>
</Style>

Here is my (simplified, again) query (xsql, Oracle 8(?)):

select
Style,
UPC

from STYLES, UPC
where instr(‘EJLU2505~EJMU2494~’ ,STYLES.Style) != 0 and
instr(‘EJLU2505~EJMU2494~’ ,UPC.Style) != 0 and STYLES.Style = UPC.STYLE(+)

Which returns:
EJLU2505 | UPC1
EJLU2505 | UPC2
EJMU2494 | UPC3

So far so good. The problem is the XML (simplified):
<!–WRONG–>
<ROWSET>

  • <ROW num=“1”>
    <STYLE>EJMU2494</STYLE>
    <UPC>1</UPC>
    </ROW>
  • <ROW num=“2”>
    <STYLE>EJLU2505</STYLE>
    <UPC>2</UPC>
    </ROW>
  • <ROW num=“3”>
    <STYLE>EJLU2505</STYLE>
    <UPC>3</UPC>
    </ROW>
    </ROWSET>

<!-- RIGHT! -->

<ROWSET>

  • <ROW num=“1”>
    <STYLE>EJMU2494</STYLE>
    <UPC>1</UPC>
    </ROW>
  • <ROW num=“2”>
    <STYLE>EJLU2505</STYLE>
    <UPC>2</UPC>
    <UPC>3</UPC>
    </ROW>
    </ROWSET>

I realize the string of styles is probably not the best way to go, but I don’t know another way to pass them. My way worked great until it was decided that the information needed to be grouped by Style, not by the sub categories (UPC, etc).

If there was a way to just loop though the xml in my xslt, that would be fine too, but I don’t know how to do that (for-each?).

How far off base am I? Suggestions? I really need to get this working, I’ll sponsor you or a Member of your choice for some help. Thanks.