Cartweaver Debugger

SiteRoot:
rsGetDiscounts is empty:
SELECT discount_id, discount_promotionalCode FROM tbl_discounts d WHERE (#7 September 2010# >= d.discount_startDate AND #7 September 2010# <= d.discount_endDate) AND d.discount_archive = False AND (d.discount_promotionalCode = '' OR d.discount_promotionalCode = '');
RelateCategoriesSecondaries: False
RelateCategoriesSecondaries: False
onSubmitAction: Confirm

rsCWGetProduct

SQL: SELECT TOP 1 product_ID, product_Name, product_Description FROM tbl_products INNER JOIN tbl_skus ON tbl_products.product_ID = tbl_skus.SKU_ProductID WHERE product_ID = 224 AND product_Archive = False AND product_OnWeb = True AND tbl_skus.SKU_ShowWeb = True AND sku_stock > 0 Records: 1
product_ID - adInteger	product_Name - adVarWChar	product_Description - adLongVarWChar
224	S17 Spinning Wheel KIT	Introducing the everyday wheel. This single treadle wheel is designed with the budget conscious spinner in mind! Smooth ball bearing operation like all our wheels, easy treadling, and a well balanced wheel that won’t disappoint! Comes as a kit with assembly instructions. A great wheel at a really great price! Wheels are made of laminated hardwood with a "birch" exterior finish.

rsCWGetUpsell

SQL: SELECT product_MerchantProductID, product_Name, upsell_id, upsell_ProdID, upsell_relProdID FROM tbl_products, tbl_prdtupsell WHERE upsell_relProdID = product_ID AND upsell_ProdID = 224 AND product_Archive = False AND product_OnWeb = True; Records: 1
product_MerchantProductID - adVarWChar	product_Name - adVarWChar	upsell_id - adInteger	upsell_ProdID - adInteger	upsell_relProdID - adInteger
LT-S10DTSpinningWheel	S10 DT Spinning Wheel	266	224	223

rsGetDiscounts is empty:
SELECT discount_id, discount_promotionalCode FROM tbl_discounts d WHERE (#7 September 2010# >= d.discount_startDate AND #7 September 2010# <= d.discount_endDate) AND d.discount_archive = False AND (d.discount_promotionalCode = '' OR d.discount_promotionalCode = '');
cwPriceList for 224
showDiscount: False

rsPricing

SQL: SELECT Min(SKU_Price) AS minPrice, Max(SKU_Price) AS maxPrice FROM tbl_skus WHERE SKU_ProductID = 224 AND SKU_ShowWeb = True AND SKU_Stock > 0 Records: 1
minPrice - adDouble	maxPrice - adDouble
330	330

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.464844E-02 s
rsCWGetProductOptions is empty:
SELECT DISTINCT tbl_prdtoption_rel.optn_rel_OptionType_ID FROM tbl_products INNER JOIN tbl_prdtoption_rel ON tbl_products.product_ID = tbl_prdtoption_rel.optn_rel_Prod_ID WHERE tbl_prdtoption_rel.optn_rel_Prod_ID = 224 AND tbl_products.product_Archive = False;
intOptionCount: 0
Page execution time: 0.53125 s

Built-in Cartweaver Variables

• versionNumber: 3.0.3
• websiteURL: http://www.alpacameadows.com/
• websiteSSLURL: http://www.alpacameadows.com/
• onSubmitAction: Confirm
• targetResults: http://www.alpacameadows.com/Results.asp
• targetDetails: http://www.alpacameadows.com/Details.asp
• targetGoToCart: http://www.alpacameadows.com/ShowCart.asp?cart=130154406
• targetCheckout: http://www.alpacameadows.com/OrderForm.asp?cart=130154406
• targetConfirmOrder: http://www.alpacameadows.com/Confirmation.asp
• cwLocale: 1033
• uploadCom:
• mailObj: ASP Mail
• mailServer: mail.alpacameadows.com
• paymentAuthType: gateway
• paymentAuthName: CWIncAuthorizeNet.asp
• dbType: Access
• ThisPage: /Details.asp
• ThisPageQS: Details.asp?ProdID=224&category=41

Application.Contents

• CompanyName: Alpaca Meadows
• CompanyAddress1: 185 Bethel Lane
• CompanyAddress2:
• CompanyCity: Mansfield
• CompanyState: OH
• CompanyZip: 44906
• CompanyCountry: USA
• CompanyPhone: (419) 529-8152
• CompanyFax: (419) 529-8152
• CompanyEmail: mandj@alpacameadows.com
• ChargeTaxonShipping: False
• DisplayLineItemTaxes: False
• DisplayTaxOnProduct: False
• TaxIDNumber: 010746180
• DisplayTaxID: False
• EnableShipping: True
• ChargeShipBase: True
• ChargeShipExtension: True
• AllowBackOrders: False
• showupsell: True
• shipcalctype: localcalc
• NumberOfColumns: 3
• ResultsPerPage: 12
• DetailsDisplay: Advanced
• ShowApplication: True
• ShowSession: True
• ShowRequest: True
• ShowServer: False
• ShowURL: True
• ShowLocal: True
• ShowForm: True
• ShowCookie: True
• ShowCGI: False
• ShowDebugLink: True
• EnableDebugging: True
• DisplayLineItemDiscount: True
• EnableDiscounts: True
• DisplayDiscountNotes: True
• ShowImageInCart: True
• ChargeShipBy: Weight
• RelateCategoriesSecondaries: True
• ShowImagePopup: True
• VersionNumber: 3.0.3
• DeveloperEmail: mandj@alpacameadows.com
• EnableErrorHandling: False
• ShowClient: True
• TaxSystem: General
• SiteRoot: /
• DefaultCountryID: 1

Session.Contents

• debug: True
• debugStatus: OFF
• availableDiscounts:
• currentDiscount:
• ShipToCountryID: 1
• CheckingOut: False

Request.Querystring

• ProdID: 224
• category: 41

Request.Form

Request.Cookies

• CartID: 130154406