midrange.com code scratchpad |
Name:
Sample XMLi Template using nested SQL and parameter markers
|
Scriptlanguage:
Plain Text
|
Tabwidth:
4
|
Date:
01/19/2011 12:21:19 am
|
IP:
Logged
|
|
Description:
Result of XMLi SQL query: http://code.midrange.com/6e4ca0011e.html
|
Code:
- <root>
- <order>
- <OrderNumber>ORDER1</OrderNumber>
- <OrderDate>2010-02-06</OrderDate>
- <OrderTotal>$288.99</OrderTotal>
- <OrderCustomer>CUSTOMER1</OrderCustomer>
- </order>
- <order>
- <OrderNumber>ORDER2</OrderNumber>
- <OrderDate>2010-02-06</OrderDate>
- <OrderTotal>$132.99</OrderTotal>
- <OrderCustomer>CUSTOMER2</OrderCustomer>
- </order>
- <order>
- <OrderNumber>ORDER3</OrderNumber>
- <OrderDate>2010-02-07</OrderDate>
- <OrderTotal>$1049.90</OrderTotal>
- <OrderCustomer>CUSTOMER1</OrderCustomer>
- </order>
- <order>
- <OrderNumber>ORDER4</OrderNumber>
- <OrderDate>2010-02-07</OrderDate>
- <OrderTotal>$995.00</OrderTotal>
- <OrderCustomer>CUSTOMER3</OrderCustomer>
- </order>
- </root>
|
|
|