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
UBound(strKeywords): -1

rsCWGetResults

SQL: SELECT tbl_products.product_ID, tbl_products.product_Name, tbl_products.product_ShortDescription FROM tbl_products WHERE tbl_products.product_ID IN (SELECT DISTINCT tbl_products.product_ID FROM (tbl_products INNER JOIN tbl_skus ON tbl_products.product_ID = tbl_skus.SKU_ProductID) LEFT JOIN tbl_prdtcat_rel ON tbl_products.product_ID = tbl_prdtcat_rel.prdt_cat_rel_Product_ID WHERE tbl_products.product_OnWeb = True AND tbl_products.product_Archive = False AND tbl_skus.SKU_Stock > 0 AND tbl_prdtcat_rel.prdt_cat_rel_Cat_ID = 41AND tbl_skus.SKU_ShowWeb = True) ORDER BY tbl_products.product_Sort, tbl_products.product_Name Records: 11
product_ID - adInteger	product_Name - adVarWChar	product_ShortDescription - adLongVarWChar
222	S10 Spinning Wheel	The Original . . .
223	S10 DT Spinning Wheel	Double Treadle . . .
224	S17 Spinning Wheel KIT	Build Your Own . . .
261	Victoria S96	Portable, Folding Wheel . . .
220	JULIA Spinning Wheel	Newest Wheel . . .
507	Table Swift / Skeinwinder	Table Model . . .
508	Floor Swift / Skeinwinder	Collapsible . . .
518	Combination Swift	Versatile . . .
519	Jumbo Ball Winder	One Pound Balls . . .
442	Niddy Noddy	Tool for Skeining . . .
149	Ball Winder	Gotta' Have A Ball Winder . . .

ResultCount: 11
NumberOfColumns: 3
ColsOutput: 0
RecordsOutput: 0
RowsOutput: 0
ColWidth: 33
Paging - TotalRecords: 11
Paging - ResultsPerPage: 12
Paging - PagingURL: PageNum_Results
Paging - ShowPageNumbers: True
Paging - ShowPrevNext: True
Paging - LinkDelimeter: |
Paging - BeforeCurrentPage:
Paging - AfterCurrentPage:
Paging - AddlURLVars: &category=41&secondary=
Paging - TotalPages: 1
Paging - CurrentPage: 1
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 222
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.611328E-02 s
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 223
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.513672E-02 s
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.611328E-02 s
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 261
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 0 s
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 220
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.611328E-02 s
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 507
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.611328E-02 s
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 508
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.464844E-02 s
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 518
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 0.03125 s
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 519
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.611328E-02 s
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 442
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 1.611328E-02 s
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 149
showDiscount: False

rsPricing

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

• DisplayTax: 0
• CalcTax: 0
• Rates

cwPriceList execution time: 0 s
Paging - TotalRecords: 11
Paging - ResultsPerPage: 12
Paging - PagingURL: PageNum_Results
Paging - ShowPageNumbers: True
Paging - ShowPrevNext: True
Paging - LinkDelimeter: |
Paging - BeforeCurrentPage:
Paging - AfterCurrentPage:
Paging - AddlURLVars: &category=41&secondary=
Paging - TotalPages: 1
Paging - CurrentPage: 1
Page execution time: 0.671875 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: /Results.asp
• ThisPageQS: Results.asp?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

• category: 41

Request.Form

Request.Cookies

• CartID: 130154406