Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2003

    Unanswered: Accessing long text fields

    Hello all,

    I'm looking for some info on the ADO Stream object. I'm trying to access a MySql database in ASP.

    I can create the connection object, generate a recordset etc without problems and return the text in the various fields with response.write etc. My problem comes with dealing with the last field which is a large text field (about 40k of text in some records) I understand that I need to use a Stream object and read/writetext etc but my docs only detail using this with a file object. Could anyone give me some idea on how to set this up with a recordset or provide me a URL? I cannot find anything on w3schools to help, and I'd buy to required book if I knew that it would work, however I don't - yet!

    Thanks in advance.

    Sorry, forgot to include. This is IIS running on Win2k SP3 using ASP v3.0 and ADO 2.5
    Last edited by Mithrandir; 08-25-03 at 14:01.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts