DISTINCT keyword problem

[defanjos]

I have the following sql statement:

SELECT DISTINCT pname, pimage, pdescription FROM tblProducts WHERE pcountry = '"& country &"' ORDER BY pname

It works, the problem is it cuts off the "pdescription" at about 300 characters, if I remove the "Distinct" from the statement the entire "pdescripion" is written on the page - does anyone know what the problem is?

[TheNige]

I'm not sure why the Distinct would have any affect on the return results. I would open Query Analyzer to execute the query to make sure what it is really returning to your code.

If it looks good then it is something in your web page code that is cutting it off.