viewing contents of field type "long text"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Thakur (pthakur_at_apsc.com)
Date: 10/19/04


Date: Mon, 18 Oct 2004 20:00:30 -0700

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



Relevant Pages

  • viewing contents of field tyep "Long Text"
    ... I need to display field values ... from a sql table consisting of several fields, one of them is of type "Long ... This field contains XML data. ... streaming object. ...
    (microsoft.public.inetserver.asp.db)
  • viewing contents of field type "long text"
    ... I need to display field values ... from a sql table consisting of several fields, one of them is of type "Long ... This field contains XML data. ... streaming object. ...
    (microsoft.public.inetserver.asp.db)
  • viewing contents of field type "long text"
    ... I need to display field values ... from a sql table consisting of several fields, one of them is of type "Long ... This field contains XML data. ... streaming object. ...
    (microsoft.public.scripting.vbscript)
  • Re: viewing contents of field type "long text"
    ... "Paul Thakur" wrote in message ... I need to display field values ... This field contains XML data. ... > streaming object. ...
    (microsoft.public.scripting.vbscript)
  • Re: viewing contents of field type "long text"
    ... "Paul Thakur" wrote in message ... I need to display field values ... This field contains XML data. ... > streaming object. ...
    (microsoft.public.inetserver.asp.db)