PRB: Sp_makewebtask Truncates Embedded Text Columns

Last reviewed: July 30, 1997
Article ID: Q171909

The information in this article applies to:

Microsoft SQL Server, version 6.5

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.

Additional query words: image WWW clip activex ADO ASP
Keywords : SSrvWeb kbusage
Version : 6.5
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.