select * from orders where customerID=#get_key.customerID# and orderID=#orderID# select * from orderDetails where orderID=#orderID# select * from customers where customerID=#get_key.customerID#

Order No.: #orderID#
Date Ordered: #dateformat(get_order.transaction_date,'mm/dd/yyyy')#

Billing Infomation

#FirstName# #LastName#
#billAddress#
#billCity#, #billState# #billcountry#
#billZip#

Shipping Infomation

#ThisFirstname# #ThisLastname#
#ThisAddress#
#ThisCity# #ThisState#, #thiscountry# #ThisZip#

Order Information

Order Number: #OrderID#

select * from items where itemcode='#itemcode#'

Item	Unit Price	Qty	Total Price
#get_desc.itemname#	#dollarFormat(unitPrice)#	#quantity#	#dollarFOrmat(lineTotal)#

	Subtotal:		#dollarFormat(totalPrice)#
	Shipping:		#dollarFormat(sh)#
	Tax:		#dollarFormat(salesTax)#
	Total:		#dollarFormat(grandTotal)#

*The Billing Information (not the shipping) may not be the same as at the time of the original order. Billing Information is updatable at any time by the end user and thus may not be accurate to this particular order.

Back to Orders List

select * from orders where customerID=#get_key.customerID# order by #order# #asc_desc#

#get_orders.recordcount# ordersfound	Previous Next
[#pageCount#] #pageCount#	Records #start#-#get_orders.recordcount##evaluate(start+maxrows-1)# of #get_orders.recordcount#

Order ID	Order Date	Order Value	Order Detail
#orderID#	#dateformat(transaction_date,'mm/dd/yyyy')#	#dollarFormat(grandTotal)#	Detail

Sorry. You have not placed any order.