select * from cartitems where cartidreference=#cookie.cartCookie# and itemcode='#itemcode#' and itemsize='#itemsize#' and itemColor='#itemColor#' select * from items where itemcode='#itemcode#' INSERT INTO CartItems (CartIDReference, Quantity, TotalPrice, ItemCode, LockPrice,itemsize,itemColor) VALUES (#Cookie.cartCookie#, 1, #get_desc.UnitPrice#*1, '#ItemCode#', #get_desc.UnitPrice#,'#itemsize#','#itemcolor#')

Your shopping cart is empty.

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

Your shopping cart is empty.

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

Delete	Description	Qty.	Unit Price	Total Price
	#get_desc.itemname# (#get_desc.itemCode#) Size: #itemsize# Color: #itemColor#		#dollarFormat(lockPrice)#	#dollarFOrmat(totalprice)#
				#dollarFormat(orderTotal)#
select * from customers where customerid=#get_key.customerID#