I have an XML document that looks like this:

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882' xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>

<s:Schema id='RowsetSchema'>
     <s:ElementType name='row' content='eltOnly' rs:updatable='true'>
         <s:AttributeType name='SKURcrd' rs:number='1' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'
            rs:basetable='Products' rs:basecolumn='SKURcrd'>
           <s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
         </s:AttributeType>  
         <s:extends type='rs:rowbase'/>
     </s:ElementType>
</s:Schema>

<rs:data>
<z:row SKURcrd='3' MfgNo='2692-3' BarCode='043699269235' MfgName='Uncle Mikes' MfgAbbv='UM' ShortDesc='Sling'
   smShortDesc='Blk Mountain Sling/Swivels 1-1/4&#x22;' Warranty='Limited lifetime warranty.' HazMatID='1' Picture='umpic26923.jpg'
   ShipWeight='0.35' ShipLength='4' ShipWidth='2' ShipHeight='12' CategoryName='Slings &#x26; Swivels' CategoryAbbv='FASL'
   CategoryParentID='90' ProductGroup='42S' GroupMisc='Mountain Nylon w/ Swivels 1&#x22; Black' GroupColorID='1'
   GroupHandID='1' GroupSizeID='1' MSRP='23.05' Level1='13.3106' Level2='12.5183' Level3='11.8151' MAP='0' MadeIn='US'
   FireSightDescription='N/A' FireSightAbbv='NA' FireStockDescription='N/A' FireStockAbbv='NA' FireAmbDescription='N/A'
   FireAmbAbbv='NA' FireFinishDescription='N/A' FireFinishAbbv='NA' FireCaliberDescription='N/A' FireCaliberAbbv='NA'
   FireModelDescription='N/A' FireModelAbbv='NA' StatusID='1' Description='Completely ready-to-use sling with 1 1/4-inch Super Swivels sewn on both ends. Tough 1 1/4&#x22; nylon web with non-slip lining. Wide enough for comfort, compact enough to roll up in your pocket. One-hand adjustment. 48&#x22;x 1 1/4&#x22;.'/>
<z:row SKURcrd='4' MfgNo='P207SS' BarCode='029465018238' MfgName='Federal Cartridge' MfgAbbv='FEDE' ShortDesc='Premium Sabot Slugs (Per 5)'
   smShortDesc='Hi-Shok Slug 20Ga. 3&#x22; 8oz./5' Warranty='Warranted against manufacturers defects.' HazMatID='2'
   Picture='fedpicpremsabotslug.jpg' ShipWeight='0.5' ShipLength='3.5' ShipWidth='2.75' ShipHeight='3.5' CategoryName='Shotgun'
   CategoryAbbv='AMSH' CategoryParentID='10' ProductGroup='19Q' GroupMisc='20ga 3&#x22; 5/8oz Hydra-Shok HP (Per 5)'
   GroupColorID='1' GroupHandID='1' GroupSizeID='1' MSRP='13.95' Level1='9.5002' Level2='9.1764' Level3='8.9724'
   MAP='0' MadeIn='US' FireSightDescription='N/A' FireSightAbbv='NA' FireStockDescription='N/A' FireStockAbbv='NA'
   FireAmbDescription='N/A' FireAmbAbbv='NA' FireFinishDescription='N/A' FireFinishAbbv='NA' FireCaliberDescription='N/A'
   FireCaliberAbbv='NA' FireModelDescription='N/A' FireModelAbbv='NA' StatusID='1' Description='Load number: P207SS Premium' />

How do I pull out the row product data, like the Barcode for each product. There will be multiple <z:row> lines.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to