viewing contents of field type "long text"
From: Paul Thakur (pthakur_at_apsc.com)
Date: 10/19/04
- Next message: Jeff Cochran: "Re: How do I command a browser screen to front from asp?"
- Previous message: Ray Costanzo [MVP]: "Re: ASP problem"
- Next in thread: Aaron [SQL Server MVP]: "Re: viewing contents of field type "long text""
- Reply: Aaron [SQL Server MVP]: "Re: viewing contents of field type "long text""
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Jeff Cochran: "Re: How do I command a browser screen to front from asp?"
- Previous message: Ray Costanzo [MVP]: "Re: ASP problem"
- Next in thread: Aaron [SQL Server MVP]: "Re: viewing contents of field type "long text""
- Reply: Aaron [SQL Server MVP]: "Re: viewing contents of field type "long text""
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|