xslt key and match -


i pretty new xslt, sorry confusion caused , may waste time... trying is: have 2 queries, first query (orders/order)

<query name="orders" rowelementname="order">  select ordernumber, subtotal, total  tablex </query> 

return like:

ordernumber subtotal total
123 20 23.5
234 19 26.5

another query (orderitems/lineitem)

<query name="orderitems" rowelementname="lineitem">  select ordernumber, cartitemid, productname, sku  tabley </query> 

return like:

ordernumber cartitemid productname sku
123 3 test1 s9sdidk
123 4 test2 s9sdidl
234 5 test3 s9sdidu
234 6 test4 s9sdidh

and output (seperate 2 orders):

product sku


test1 s9sdidk
test2 s9sdidl


     subtotal:  20.00          total: 23.5  

product sku


test3 s9sdidu
test4 s9sdidh


     subtotal:  19.00          total: 26.5  


Comments

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -