SELECT * FROM CartItems WHERE CartIDReference = #Cookie.cartCookie# ORDER BY CartItemID

Thank you, #firstname# #lastname#.
The following is a final preview of your order information.

select * from items where itemcode='#itemcode#' select * from StateTax where state ='#billstate#'
  Description
Qty.
Unit Price
Total Price
Image
N/A
#quantity#
#dollarFormat(lockPrice)#
#dollarFOrmat(totalprice)#
 Total: 
#dollarFormat(orderTotal)#
 Tax: 
#dollarFormat(tax)#
 Shipping: 
#dollarFormat(sh)#
 Grand Total: 
#dollarFormat(grandTotal)#

select * from #get_softwareID.shipping# where sh=#sh#
Billing Address Shipping Address
#firstname# #lastname#
#BillAddress#
#billcity# #billstate#, #billZip#

#firstName# #lastName#
#BillAddress#
#billCity# #billState#, #billZip# #shipFirstname# #shipLastname#
#shipAddress#
#shipCity# #shipState#, #shipZip# #ThisFirstname# #ThisLastname#
#ThisAddress#
#ThisCity# #ThisState#, #ThisZip#


Credit Card Number Credit Card Expiration
select ccnumber from customers where customerID=#get_key.customerID# #Left(ccnumber,2)#**********#Right(ccnumber,4)#

#ccexpmo#/#right(ccexpyr,2)#

Shipping Method
#dollarFOrmat(sh)# - #get_shipping.desc# #dollarFOrmat(sh)#