viewing contents of field type "long text"

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,164
Messages
2,570,901
Members
47,439
Latest member
elif2sghost

Latest Threads

Top