Accessing Text or Memo Fields in ASP Returns No Data (200124)




This article was previously published under Q200124

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 175239, "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: 175239
TITLE: 80020009 Error When Retrieving Data from SQL

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

Modification Type: Major Last Reviewed: 7/30/2001
Keywords: kbDatabase kbinfo KB200124
©2002 Microsoft Corporation. All rights reserved.