Microsoft KB Archive/171909

From BetaArchive Wiki
Knowledge Base


PRB: Sp_makewebtask Truncates Embedded Text Columns

Article ID: 171909

Article Last Modified on 2/14/2005



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



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.


  1. Use Active Server Pages and Active Data Objects.
  2. Use IDC scripts.
  3. Use CGI scripts.




Additional query words: image WWW clip activex ADO ASP

Keywords: kbprb kbusage KB171909