[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: FW: key, generate-id, ignoring my template

Subject: RE: FW: key, generate-id, ignoring my template
From: "Laura Madonna" <Laura.Madonna@xxxxxxxxx>
Date: Tue, 23 Mar 2004 11:49:03 -0700
key generate
Thank you for all this information.  I have been studying it this morning and trying to apply it to what I am doing.
To answer your question:  "What is it that you are trying to accomplish here?"
The data is given to me in xml in rows from the database, one row per Benefit_Plan and Covrg_desc combination.  I need the distinct <benefit_plan> and <plan_desc> to display once and all the associated <covrg_desc> to display.

I have Medical and Dental data to group.  I want the Medical Data first.  Right now, I get all the Medical Plans and the Dental plans in the same table.

I have stripped down the XML to be easier to deal with - it is below this mock-up of how I want the data displayed.

_______________________________________________________
PacifiCare/UA NetBasic   | Employee Only  
                         | Employee+Spouse/DomesticPartnr 
                         | Employee + Child(ren)  
                         | Family 
_______________________________________________________
PacifiCare / UA Net Direct| Employee Only  
                          | Employee+Spouse/DomesticPartnr 
                          | Employee + Child(ren)  
                          | Family 
_______________________________________________________ 
PacifiCare / UA Net Choice| Employee Only  
                          | Employee+Spouse/DomesticPartnr 
                          | Employee + Child(ren)  
                          | Family 
_______________________________________________________ 
=== xml ===
<?xml version='1.0'?>
<form>
   <page name='MEDICAL'>    
        <heading2> 2004 Medical Options for Wxxxx,Donald x</heading2>                       
            <pcp>
               <row number='0'>                 
                  <benefit_plan>PBASIC</benefit_plan>
                  <plan_desc>PacifiCare / UA Net Basic</plan_desc>                
                  <covrg_desc>Employee Only</covrg_desc>
                  <price>109.1</price>                               
               </row>   
               <row number='1'>                   
                  <benefit_plan>PBASIC</benefit_plan>
                  <plan_desc>PacifiCare / UA Net Basic</plan_desc>                      
                  <covrg_desc>Employee+Spouse/DomesticPartnr</covrg_desc>
                  <price>283.61</price>                 
                </row>
                <row number='2'>                   
                  <benefit_plan>PBASIC</benefit_plan>
                  <plan_desc>PacifiCare / UA Net Basic</plan_desc>                      
                  <covrg_desc>Employee+Child</covrg_desc>
                  <price>283.61</price>                 
                </row>
              <row number='3'>
                <benefit_plan>PBASIC</benefit_plan>
                <plan_desc>PacifiCare / UA Net Basic</plan_desc>
                <covrg_desc>Family</covrg_desc>
                <price>391.51</price>         
              </row>
              <row number='4'>
               <benefit_plan>PDIRCT</benefit_plan>
               <plan_desc>PacifiCare / UA Net Direct</plan_desc>
               <covrg_desc>Employee Only</covrg_desc>
               <price>127.55</price>                
             </row>
             <row number='5'>
               <benefit_plan>PDIRCT</benefit_plan>
               <plan_desc>PacifiCare / UA Net Direct</plan_desc>
               <covrg_desc>Employee+Spouse/DomesticPartnr</covrg_desc>
               <price>314.01</price>
             </row>
             <row number='6'>
               <benefit_plan>PDIRCT</benefit_plan>
               <plan_desc>PacifiCare / UA Net Direct</plan_desc>
               <covrg_desc>Employee + Child(ren)</covrg_desc>
               <price>292.92</price>
             </row>
             <row number='7'>
               <benefit_plan>PDIRCT</benefit_plan>
               <plan_desc>PacifiCare / UA Net Direct</plan_desc>
               <covrg_desc>Family</covrg_desc>
               <price>442.7</price>
             </row>
             <row number='8'>
               <benefit_plan>PCHOIC</benefit_plan>            
               <plan_desc>PacifiCare / UA Net Choice</plan_desc>
               <covrg_desc>Employee Only</covrg_desc>
               <price>181.08</price>
             </row>
             <row number='9'>
                 <benefit_plan>PCHOIC</benefit_plan>
                 <plan_desc>PacifiCare / UA Net Choice</plan_desc>
                 <covrg_desc>Employee+Spouse/DomesticPartnr</covrg_desc>
                 <price>426.7</price>
             </row>
             <row number='10'>
                <benefit_plan>PCHOIC</benefit_plan>
                <plan_desc>PacifiCare / UA Net Choice</plan_desc>
                <covrg_desc>Employee + Child(ren)</covrg_desc>
                <price>394.07</price>
             </row>                
             </pcp>     
   </page>
   <page name='DENTAL'>     
            <heading2>2004 Dental Options for Wxxxx,Donald x</heading2>                                              
            <pcp>
               <row number='0'>                  
                  <benefit_plan>DEPO</benefit_plan>
                  <plan_desc>Delta Exclsv Pnl Optn</plan_desc>                 
                  <covrg_desc>Employee Only</covrg_desc>
                  <price>0</price>                               
               </row>
               <row number='1'>                 
                  <benefit_plan>DEPO</benefit_plan>
                  <plan_desc>Delta Exclsv Pnl Optn</plan_desc>               
                  <covrg_desc>Employee+Spouse/DomesticPartnr</covrg_desc>
                  <price>13.5</price>                               
               </row>
               <row number='2'>                
                  <benefit_plan>DEPO</benefit_plan>
                  <plan_desc>Delta Exclsv Pnl Optn</plan_desc>                  
                  <covrg_desc>Employee + Child(ren)</covrg_desc>
                  <price>16.36</price>                                   
               </row>                                                 
         </pcp>                  
   </page>
</form>

-----Original Message-----
From: M. David Peterson [mailto:m.david@xxxxxxxxxx]
Sent: Tuesday, March 23, 2004 12:50 AM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE:  FW: key, generate-id, ignoring my template

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.