Accessing Text or Memo Fields in ASP Returns No Data

SUMMARY

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 Q175239, "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.

MORE INFORMATION

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:

ARTICLE ID: Q175239
TITLE: 80020009 Error When Retrieving Data from SQL

ARTICLE ID: Q194975
TITLE: Sample Functions Demonstrating GetChunk and AppendChunk[adobj]

Additional query words: sql ado text fields empty

Keywords : kbDatabase kbODBC
Version :
Platform :
Issue type : kbinfo