CF_eConstruct ALERT!
Message: File #attributes.viewBagHREF# is missing. Process aborted.
Consult your documentation for help.

CF_eConstruct ALERT!
Message: File eConstruct_appGlobals.cfm is missing. Process aborted.
Consult your documentation for help.

SELECT * FROM qryCurrentMemberships WHERE memberid = #varMemberID# SELECT * FROM qryCurrentMemberships WHERE (fname='#form.sfname#' AND lname='#form.slname#')

You are listed in our database as a Paid Member, which entitles you to a 10% discount on all of your purchases!

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 AS a LEFT JOIN Discounts AS 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) 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 = #ProductAttributes.productID# GROUP BY a.name, a.nameid, a.required

Items In Cart: #varTotalQty# Total: #dollarFormat(varTotal)#

Items In Cart: #varTotalQty# Total: #dollarFormat(varTotal)# +