note 31760 added to function.mssql-query

From: 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

« previous php.notes (#47392) next »