note 31760 added to function.mssql-query
| From: | thomas dot cochran at ams dot com | Date: | Fri, 02 May 2003 17:24:26 +0000 |
| Subject: | note 31760 added to function.mssql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-47392@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'
--
http://www.php.net/manual/en/function.mssql-query.php
http://master.php.net/manage/user-notes.php?action=edit+31760
http://master.php.net/manage/user-notes.php?action=delete+31760
http://master.php.net/manage/user-notes.php?action=reject+31760