Accessing Text or Memo Fields in ASP Returns No Data

Some or all the text fields in a query result row may return no data when the field is declared as a text field in SQL Server. This can still happen after changing the order of your query as described in the Microsoft Knowledge Base article 175239  (http://support.microsoft.com/kb/175239/EN-US/ ) , "Place the BLOB/Text Fields at the End of the Query."

When you try to read data from a query that contains more than one text field you may be unable to read the data from the text fields declared after the first text field in the query.

The text fields being accessed should be treated as a BLOB field.

Reading and writing data to BLOBs requires you to use the recordset.fields("fieldname").AppendChunk and .GetChunk methods.

Consult the Windows NT Option Pack online documentation for more information on GetChunk and AppendChunk.

For technical information on how ODBC drivers treat BLOB fields, see the "MORE INFORMATION" section in the following Microsoft Knowledge Base articles: