SELECT * FROM CartItems WHERE CartIDReference = #cartid# ORDER BY CartItemID

Sorry. Your credit card was denied.
insert into customers (CompName,FirstName,LastName,BillAddress,BillCity,BillState,BillCountry,BillZip,Phone,Email ,ccname,ccnumber,ccexpmo,ccexpyr,cctype,username,password,shipfirstName,shipLastName,shipAddress,shipCity,shipState,shipCountry,shipZip) values('#CompName#','#FirstName#','#LastName#','#BillAddress#','#BillCity#','#BillState#','#BillCountry#','#BillZip#','#Phone#','#Email#' ,'#ccname#','#ccnumber#','#ccexpmo#','#ccexpyr#','#cctype#','#username#','#password#','#shipfirstName#','#shipLastName#','#shipAddress#','#shipCity#','#shipState#','#shipCountry#','#shipZip#') select max(customerID) as curr_customerID from customers update customers set CompName='#CompName#',FirstName='#FirstName#',LastName='#LastName#',BillAddress='#BillAddress#',BillCity='#BillCity#',BillState='#BillState#',BillCountry='#BillCountry#',BillZip='#BillZip#',Phone='#Phone#',Email='#Email#' ,ccname='#ccname#',ccnumber='#ccnumber#',ccexpmo='#ccexpmo#',ccexpyr='#ccexpyr#',cctype='#cctype#',shipfirstName='#shipfirstName#',shipLastName='#shipLastName#',shipAddress='#shipAddress#',shipCity='#shipCity#',shipState='#shipState#',shipCountry='#shipCountry#',shipZip='#shipZip#' where customerID=#get_key.customerID# insert into orders (CustomerID,thisfirstName,thislastName,thisAddress,thisCity,thisState,thisCountry,thisZip,ccname,ccnumber,ccexpmo,ccexpyr,TotalPrice,SH,SalesTax,GrandTotal,transaction_date) values(#form.customerID##get_key.customerID#,'#thisfirstName#','#thislastName#','#thisAddress#','#thisCity#','#thisState#','#thisCountry#','#thisZip#','#ccname#','#ccnumber#','#ccexpmo#','#ccexpyr#',#orderTotal#,#SH#,#Tax#,#GrandTotal#,now()GetDate()) select max(orderID) as curr_orderID from orders SELECT * FROM CartItems WHERE CartIDReference = #cartID# ORDER BY CartItemID delete FROM CartItems WHERE CartIDReference = #cartID# insert into orderDetails values(#orderID#,#currentrow#,'#itemcode#',#quantity#,#lockPrice#,#totalPrice#) update items set qty=qty-#quantity# where itemcode='#itemcode#' select qty from items where itemcode='#itemcode#' There are only #get_qty.qty# items left for #itemcode#.
Thank you!

Your order has been placed. For future reference print out the invoice below or review your order at any time by selecting the "order history" option under "my account.*"

   
Billing Infomation
#FirstName# #LastName#
#billAddress#
#billCity#, #billState#, #billcountry#
#billZip#
Shipping Infomation
#firstName# #lastName#
#BillAddress#
#billCity# #billState#, #billcountry# #billZip# #shipFirstname# #shipLastname#
#shipAddress#
#shipCity# #shipState#, #shipcountry# #shipZip# #ThisFirstname# #ThisLastname#
#ThisAddress#
#ThisCity# #ThisState#, #thisCountry# #ThisZip#

Payment Infomation
#cctype#
#Left(ccnumber,2)#**********#Right(ccnumber,4)#
#ccexpmo#/#right(ccexpyr,2)#
 
   
Order Information

Order Number: #OrderID#

select * from items where itemcode='#itemcode#'
Item
Unit Price
Qty
Total Price
#get_desc.itemname#
Size: #itemsize#    #itemColor#
#dollarFormat(lockPrice)#
#quantity#
#dollarFOrmat(totalprice)#
       
 
Subtotal:
#dollarFormat(orderTotal)#
 
Shipping:
#dollarFormat(sh)#
 
Tax:
#dollarFormat(tax)#
 
Total:
#dollarFormat(grandTotal)#

 

Gift Shop

Home Page

*orders may not appear immediately in the "order history" section of "my account."

The following order was placed through your shopping cart:

Sportsline ID: #sportslineID#

------------------------ Invoice No: #orderID#

Company : #form.CompName#
Name : #form.LastName#, #form.FirstName#

Address :
#form.BillAddress#
#form.BillCity#, #form.BillState# #form.BillZip#

Phone : #form.Phone#
Email : #form.Email#

Ship to : #ThisFirstname# #ThisLastname#
#form.thisAddress#
#form.thisCity#, #form.thisState# #form.thisZip#

Customer is tax exempted.
Tax exemption certificate no: #form.TaxExemptCert#

Credit card : #form.cctype#
Card number : #form.ccnumber#
Exp. date : #form.ccexpmo#/#form.ccexpyr#
Card ID: #form.CcID#
Name on card: #form.ccname#

------------------------ Products:

#CurrentRow#.
Item Code: #ItemCode#
select itemname from items where itemcode = '#ItemCode#' Item Name: #get_item_name.ItemName#
Item Size: #itemsize#
 #itemColor#
 Item Qty: #Quantity#
Line Total: #DollarFormat(TotalPrice)#
-------------------------
 -------------------------
Sub total: #DollarFormat(form.orderTotal)#
S/H : #DollarFormat(SH)#
Sales Tax: #DollarFormat(tax)#
-------------------------------------------
Grand Tot: #DollarFormat(grandTotal)# Thank you for your purchase. Below is your invoice. ------------------------ Invoice No: #orderID# Company : #form.CompName# Name : #form.LastName#, #form.FirstName# Address : #form.BillAddress# #form.BillCity#, #form.BillState# #form.BillZip# Phone : #form.Phone# Email : #form.Email# Ship to : #ThisFirstname# #ThisLastname# #form.thisAddress# #form.thisCity#, #form.thisState# #form.thisZip# Customer is tax exempted. Tax exemption certificate no: #form.TaxExemptCert# Products: #CurrentRow# Item Code: #ItemCode# select itemname from items where itemcode = '#ItemCode#' Item Name: #get_item_name.ItemName# Item Size: #itemsize# #itemColor# Item Qty: #Quantity# Line Total: #DollarFormat(TotalPrice)# ------------------------------------------- Sub total: #DollarFormat(form.orderTotal)# S/H : #DollarFormat(SH)# Sales Tax: #DollarFormat(tax)# ----------------------- Grand Tot: #DollarFormat(grandTotal)#