Unable to retrieve text from varchar(max)

Hi all,

I've got a SQL Server 2005 Express Edition db running on Win2003 SP1 with a
varchar(max) field and an ASP that retrieves text from the varchar(max) field
and outputs it.

Only problem is, nothing gets output. Page runs without error and all other
fields are output but where the varchar(max) field should be, there's nothing.

There are no error messages in the logs. Any ideas?


--
Sean.

RE: Unable to retrieve text from varchar(max)

Disregard. I finally found the problem. "SELECT *" is bad!

http://databases.aspfaq.com/database/what-is-wrong-with-sele ct.html


--
Sean.