#title# #msg# Checkout failed! #caller.msgString# Please try again. https://#cgi.server_name##cgi.path_info##thisPage#" method="POST" name="shoppingCart" enctype="application/x-www-form-urlencoded"> SELECT a.*, b.DiscountType, b.DiscountAmount, b.DiscountEndDate, b.DiscountStartDate, (select count(*) from OptionName where OptionName.ProductID = a.ProductID) as optionCount, UnitPrice, WholesalePrice FROM (Products a LEFT OUTER JOIN Discounts b ON (a.ProductID = b.ProductID)) LEFT JOIN ProductsPrice e ON a.productID = e.ProductID WHERE a.ProductID = #varBasketProductID# AND (#varBasketQuantity# >= e.QtyBeginRange and #varBasketQuantity# <= e.QtyEndRange) "#tablebgColor#""#altRowBgColor#">   Product Options Price Qty. Amount #htmleditformat(productname)# New! SELECT a.name, a.nameid, a.required FROM OptionName a INNER JOIN OptionValue b ON (a.nameID = b.nameID) and (a.productid = b.productid) WHERE a.productid = #ItemsLong.productID# GROUP BY a.name, a.nameid, a.required SELECT * FROM OptionValue WHERE nameID = #nameID# and Active = 1 ORDER BY value_desc #name#: ---Select One--- None selected>#value_desc# +#dollarformat(Addcost)# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - (unitprice * ".1"))# #addText# #dollarFormat(UnitPrice)# #dollarFormat(WholesalePrice)# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - (unitprice * memberDiscountAmount))# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - memberDiscountAmount)# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - (unitprice * DiscountAmount))# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - DiscountAmount)# #addText# #dollarFormat(UnitPrice)# #addText# #dollarFormat(varUnitPrice * varBasketQuantity)# Total Quantity: #numberformat(totalQty, '___,___')# Subtotal: #dollarformat(totalAmt)# Note: To continue and checkout now, please enter your shipping information and click 'checkout' to proceed. Fields with an * is required. Shipping Information *First Name: *Last Name: Company Name: Military Unit: Telephone: Shipping Address *Address: *City: *US State (If country is USA): *Required if Country is USA* *Province: *Required if Country is NOT the USA* *Zip/Postal Code: *Required if Country is USA* *Country: Note: Overseas shipments will incur a $#decimalformat(outofcountrycharge)# charge. Billing Information is the same as Shipping? Yes No Yes No   Your basket is empty!