viewing contents of field tyep "Long Text"

I am writing vbscript code in an .asp page. I need to display field values
from a sql table consisting of several fields, one of them is of type "Long
Text". This field contains XML data. I like to be able to assign vale of
this field to a variable, display it and write out a text file using file
streaming object.

When I set a variable to this field, the data is truncated. I am using
"Recordset" object, is that not an appropriate type to retrieve
fields.

Any help will be appreciated.
Thanks,
Paul

Re: viewing contents of field tyep "Long Text"

Have you tried this:
http://support.microsoft.com/?id=200124

Cheers
Ken

"Paul Thakur" wrote in message
news:O2LBacYtEHA.3572@tk2msftngp13.phx.gbl...
>I am writing vbscript code in an .asp page. I need to display field values
> from a sql table consisting of several fields, one of them is of type
> "Long
> Text". This field contains XML data. I like to be able to assign vale of
> this field to a variable, display it and write out a text file using file
> streaming object.
>
> When I set a variable to this field, the data is truncated. I am using
> "Recordset" object, is that not an appropriate type to retrieve > Text>
> fields.
>
> Any help will be appreciated.
> Thanks,
> Paul
>
>