note 31760 rejected from function.mssql-query by spic
| From: | spic@php.net | Date: | Fri, 02 May 2003 17:39:33 +0000 |
| Subject: | note 31760 rejected from function.mssql-query by spic | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-47396@lists.php.net to get a copy of this message | ||
I cannot get my query to work. All values are returned, but the DOC_SECTIONS.CONTENT field will not
return more than 4096 characters. This field contains large text fields and I need to return all.
Please help.
/* BELOW IS MY QUERY */
SET TEXTSIZE 50000;
SELECT
@@TEXTSIZE AS [MAX TEXTSIZE],
DOCUMENTS.DOCUMENT + '[' + DOC_SECTIONS.DOCID + ']' AS [DOC],
DOC_SECTIONS.SECTIONID,
DOC_SECTIONS.TITLE,
CAST( DOC_SECTIONS.CONTENT as text ) AS CONTENT
FROM DOC_SECTIONS
LEFT JOIN DOCUMENTS ON DOCUMENTS.DOCID = DOC_SECTIONS.DOCID
WHERE SECTIONID = '5'