Canadian Mathematical Society

CMS Home
Publications Info
Printable Order Form
Subscription Form
feedback

CMS Shopping Site

CATEGORIES

/cms/www/htdocs/CMS /shop/ Categories.dbq SELECT ID, NameEng, DescriptionEng, (SELECT COUNT(ID) FROM Inventory WHERE InventoryGroup_ID IN (SELECT ID FROM InventoryGroup WHERE Category_ID = Category.ID) AND isdiscontinued = 0 LIMIT 1) AS InvCount FROM Category WHERE IsActive = 1 ORDER BY RowOrder ASC Unable to allocate SQL statement handle-1

SHOP

-

/cms/www/htdocs/CMS /shop/ Inventory.dbq SELECT ID, NameEng, DescriptionEng, InventoryGroup_ID, (SELECT Category_ID FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Category_ID, (SELECT Price FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Price, (SELECT MemberPrice FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS MemberPrice, (SELECT Pages FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Pages, (SELECT Authors FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Authors, (SELECT ISBN FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS ISBN, (SELECT Type FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Type, (SELECT Year FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Year, (SELECT Publisher FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS Publisher, (SELECT ShippingGroup_ID FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS ShippingGroupID, (SELECT COUNT(ID) FROM Inventory AS I2 WHERE I2.VolumeNumber = Inventory.VolumeNumber AND I2.InventoryGroup_ID = Inventory.InventoryGroup_ID LIMIT 1) AS VolumeCount, VolumeNumber, UnitsInHouse, UnitsOffSite, UnitsOnOrder, (SELECT SUM(Qty) FROM Cart WHERE Inventory_ID = Inventory.ID AND OrderStatus_ID IN (1, 2) LIMIT 1) AS UnitsInCarts, (SELECT SUM(Qty) FROM Cart WHERE Inventory_ID = Inventory.ID AND OrderStatus_ID IN (3, 4) LIMIT 1) AS UnitsSold, (SELECT SUM(Qty) FROM Cart WHERE Inventory_ID = Inventory.ID AND CID = 'Eng.20130224093736.199.87.252.180' LIMIT 1) AS UnitsInMyCart, IsDiscontinued, (SELECT LowStock FROM InventoryGroup WHERE ID = InventoryGroup_ID) AS LowStock FROM Inventory WHERE IsDiscontinued <> 1 AND InventoryGroup_ID = 016 ORDER BY NameEng ASC, DescriptionEng ASC Unable to allocate SQL statement handle-1 Error: /cms/www/htdocs/CMS/shop/Inventory.Template SELECT NameEng FROM Category WHERE ID= Unable to allocate SQL statement handle-1 Error: /cms/www/htdocs/CMS/shop/Inventory.Template SELECT NameEng FROM InventoryGroup WHERE ID=0 Unable to allocate SQL statement handle-1

SHOPPING CART

You have 0 items in your cart.

FEATURED ITEMS

/cms/www/htdocs/CMS /shop/ FeaturedItems.dbq SELECT ID, NameEng, DescriptionEng, (SELECT NameEng FROM Category WHERE ID = (SELECT Category_ID FROM InventoryGroup WHERE ID = InventoryGroup_ID)) AS CategoryName FROM Inventory WHERE IsDiscontinued <> 1 ORDER BY ((ID*1531) % (53+51)) ASC, ID ASC LIMIT 5 Unable to allocate SQL statement handle-1
Error: /cms/www/htdocs/CMS/shop/Default.Template Connect failed: [unixODBC]FATAL: connection limit exceeded for non-superusers Error: /cms/www/htdocs/CMS/shop/Default.Template DELETE FROM Cart WHERE OrderStatus_ID IN (2, 6) AND LastActivityDate + 7 < '2017-01-21 21:37:50' Unable to allocate SQL statement handle-1 Error: /cms/www/htdocs/CMS/shop/Default.Template SELECT OrderStatus_ID FROM Cart WHERE CID='Eng.20130224093736.199.87.252.180' Unable to allocate SQL statement handle-1 Error: /cms/www/htdocs/CMS/shop/Default.Template SELECT SUM(Qty) AS ItemsInCart FROM Cart WHERE CID = 'Eng.20130224093736.199.87.252.180' LIMIT 1 Unable to allocate SQL statement handle-1