PRB: Sp_makewebtask Truncates Embedded Text Columns (171909)
The information in this article applies to:
This article was previously published under Q171909 SYMPTOMS
The description of the @blobfmt parameter of the sp_makewebtask stored
procedure states that it:
Specifies whether all columns of text or image datatypes should be
embedded in the same results page (NULL, the default)...
However, if you embed a text column in the result page, it will be
truncated after the 255th character.
WORKAROUND
There are several ways to work arounds this problem. Choose the one of the
following, as appropriate for your application:
- Use the @blobfmt to add text as an URL. This will work for data up to
4 KB.
- Use Active Server Pages and Active Data Objects.
- Use IDC scripts.
- Use CGI scripts.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbprb kbusage KB171909 |
|---|
|