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: 131637
DATE_TIME: 9/9/2010 3:12:29 PM
REMOTE_ADDR: 38.107.191.88
HTTP_REFERER: 
URL: www.improvenetpro.com/ext/manufacturerlistings/ML_2.html?GID=3
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=3 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