It has nothing to do with thecustomization but that the query prior to the one I sent you that has causedthe problem – the query returned an error of “Query timeout expired.” Result of the execution of that query wasn’t being checked by theprogram, so the following query in the program (the one I sent you) inheritedthe error and caused the error checking to fail following the execution andthus, ended the program.  

 

SELECT TOP 150 A.idProduct, A.sku, A.description, A.price,A.listHidden, A.listPrice, A.serviceSpec, A.bToBPrice, A.smallImageUrl,A.noprices, A.stock, A.noStock, A.pcprod_HideBTOPrice, A.pcProd_BackOrder,A.FormQuantity, A.pcProd_BackOrder, A.pcProd_BTODefaultPrice, cast(A.sDesc asvarchar(8000)) sDesc FROM products A WHERE (A.active=-1 AND A.removed=0 ANDA.configOnly=0 AND A.idProduct IN (SELECT B.idProduct FROM categories_productsB INNER JOIN categories C ON C.idCategory=B.idCategory WHERE C.iBTOhide=0 ANDC.pccats_RetailHide=0) AND (A.idProduct IN (SELECT D.pcProd_ParentPrd FROMproducts D WHERE D.active=0 AND D.pcProd_SPInActive=0 ANDD.pcProd_ParentPrd>0 AND D.removed=0 AND ((D.serviceSpec<>0 ANDD.pcProd_BTODefaultPrice>=0 AND D.pcProd_BTODefaultPrice<=20) OR(D.serviceSpec=0 AND D.configOnly=0 AND D.price>=0 AND D.price<=20)) )))

err.number=-2147217871; err.description='Querytimeout expired'

SELECT TOP 150 A.idProduct, A.sku, A.description, A.price, A.listHidden,A.listPrice, A.serviceSpec, A.bToBPrice, A.smallImageUrl, A.noprices, A.stock,A.noStock, A.pcprod_HideBTOPrice, A.pcProd_BackOrder, A.FormQuantity,A.pcProd_BackOrder, A.pcProd_BTODefaultPrice, cast(A.sDesc as varchar(8000))sDesc FROM products A WHERE (A.active=-1 AND A.removed=0 AND A.idProduct IN(SELECT B.idProduct FROM categories_products B INNER JOIN categories C ONC.idCategory=B.idCategory WHERE C.iBTOhide=0 AND C.pccats_RetailHide=0) AND((A.serviceSpec<>0 AND A.pcProd_BTODefaultPrice>=0 ANDA.pcProd_BTODefaultPrice<=20) OR (A.serviceSpec=0 AND A.configOnly=0 ANDA.price>=0 AND A.price<=20)) ) ORDER BY A.sku ASC, A.idproduct DESC

err.number 13; err.description='Type mismatch'

 The advised I need to ask about  tmpNewQuery3in showSearchResults.asp returned err.number=-2147217871;err.description='Query timeout expired').