ERROR OCCURED - PLEASE READ INSTRUCTIONS BELOW
Look at ERROR: below. It may help you resolve the problem (eg. wrong input on the previous page). If not, contact support and provide information displayed on this screen (or at least the REF #).
REF: 282026
DATE_TIME: 9/9/2010 3:24:18 PM
REMOTE_ADDR: 38.107.191.87
HTTP_REFERER:
URL: www.improvenetpro.com/ext/manufacturerlistings/ML_2.html?GID=2
ERROR: The text, ntext, or image data type cannot be selected as DISTINCT.
SQL: SELECT DISTINCT M.*,G1.Name FROM silver_dg..PS_Group G1 (nolock),silver_dg..PS_Group G2 (nolock),silver_dg..Manufacturer M (nolock),silver_dg..ManufacturerGroup_Link ML (nolock) WHERE G1.ID=2 AND G2.ParentID=G1.ID AND M.ID=ML.ManufacturerID AND ML.GroupID=G2.ID AND ML.LinkType=1 ORDER BY M.CompanyName
APP: SILVER