An error occurred executing the following query, and page execution has been terminated.

SELECT DISTINCTROW CAT_ID, P_ID, P_VersionDisplayType, P_OrderVersionsBy, P_StrapLine1, tblCactuShop1Products.P_Desc1 as P_Desc1, P_Name1, P_Type, MIN(V_Price) As MinPrice, MIN(T_TaxRate) As MinTaxRate FROM ((((tblCactuShop1Categories c INNER JOIN tblCactuShop1ProductCategoryLink pcl ON c.CAT_ID = pcl.PCAT_CategoryID) INNER JOIN tblCactuShop1Products ON pcl.PCAT_ProductID = tblCactuShop1Products.P_ID) INNER JOIN tblCactuShop1Versions v ON tblCactuShop1Products.P_ID = v.V_ProductID) INNER JOIN tblCactuShop1TaxRates t on v.V_Tax = t.T_ID) LEFT OUTER JOIN tblCactuShop1Suppliers s ON tblCactuShop1Products.P_SupplierID = s.SUP_ID WHERE P_Name1 <> '' AND V_Live = 'y' AND V_CustomerGroupID IN (0,0) AND P_Live = 'y' AND P_CustomerGroupID IN (0,0) AND CAT_Live = 'y' AND CAT_CustomerGroupID IN (0,0) AND CAT_ID=232 AND (SUP_Live <> 'n' OR SUP_Live IS NULL) GROUP BY CAT_ID, P_ID, P_VersionDisplayType, P_OrderVersionsBy, P_StrapLine1, tblCactuShop1Products.P_Desc1 , P_Name1, P_Type ORDER BY P_Name1

Error Description : Not enough space on temporary disk.

Page of error : /prodtype.asp

Query String :

strParents=&CAT_ID=232&numRecordPosition=1