Microsoft KB Archive/200124

= Accessing Text or Memo Fields in ASP Returns No Data =

Article ID: 200124

Article Last Modified on 7/30/2001



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]

Additional query words: sql ado text fields empty

Keywords: kbinfo kbdatabase kbfaq KB200124

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.