Access long text fields
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