viewing contents of field type "long text"

[Paul Thakur]

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 <long Text>
fields.

Any help will be appreciated.
Thanks,
Paul

[Aaron [SQL Server MVP]]

Re: viewing contents of field type &quot;long text&quot;

http://www.aspfaq.com/2188

--

http://www.aspfaq.com/

(Reverse address to reply.)




"Paul Thakur" <pthakur@apsc.c om> wrote in message
news:eXTREeYtEH A.2516@TK2MSFTN GP11.phx.gbl...[color=blue]
> 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[/color]
"Long[color=blue]
> 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 <long[/color]
Text>[color=blue]
> fields.
>
> Any help will be appreciated.
> Thanks,
> Paul
>
>[/color]