READTEXT - Returning large text

Hi, I am using READTEXT and WRITETEXT to read/write data to a field (data type, Text) in my MS SQL db. The WRITETEXT part works, as I have checked the length of the text stored using DATALENGTH, however, I cannot get READTEXT to return anything greater than 4095 characters. I have tried setting TEXTSIZE, and everything else I can think of. Does anyone have any ideas? I include the code I am using below... ###PHP Code $conn=odbc_connect("vbwcontent","",""); $sql="read_content $pageid"; $q_content=odbc_exec($conn, $sql); echo (odbc_result($q_content,"Content")); ####MSSQL Stored Procedure CREATE PROCEDURE read_content (@Item_ID INT) AS DECLARE @Text_Pointer VARBINARY(16) SELECT @Text_Pointer = TEXTPTR(Content) FROM Article_Pages WHERE ArticlePageID = @Item_ID SET TEXTSIZE 25450 READTEXT Article_Pages.Content @Text_Pointer 0 25400 Help! Thanks, - James ================== Email - james@vbweb.co.uk ICQ# - 60612011 Fax - 0870 7064574 Websites www.vbweb.co.uk www.vbwebdev.com www.ccrowley.f9.co.uk ================== -----Original Message----- From: php-general-digest-help@lists.php.net [mailto:php-general-digest-help@lists.php.net] Sent: 18 October 2000 08:21 To: php-general@lists.php.net Subject: php-general Digest 18 Oct 2000 07:20:56 -0000 Issue 293 php-general Digest 18 Oct 2000 07:20:56 -0000 Issue 293 Topics (messages 20689 through 20810): Re: Primary Key? 20689 by: jeremy brand 20690 by: LAST JEDI 20693 by: Wee Chua 20706 by: Zipkid Good ASP Reference? 20691 by: joe.jWebMedia.com 20697 by: Thomas Deliduka 20741 by: Michael Kimsal 20742 by: Mark Peoples Fileupload: Nothing in TMP-dir 20692 by: Oliver Kuhl 20728 by: idban secandri 20749 by: Bojan Gajic Re:[PHP] Generating bar codes 20694 by: John Parker 20700 by: rip Multiple replacements (WML/PHP) 20695 by: Johan Mjvnes 20785 by: Matthias Endler Double message 20696 by: Enrico Comini 20765 by: Maxim Maletsky Re: apache log file report generator 20698 by: Eric Wood 20701 by: Jeffrey A Schoolcraft newbie: best way to check if there is a current session using php4 sessions? 20699 by: Oguz Re: directory info 20702 by: Zipkid 20715 by: LAST JEDI Re: [PHP-DB] MySQL (2 tables) 20703 by: Jason Cox 20705 by: Jason Cox PHP4.03PL1 INSTALLATION 20704 by: alexus 20711 by: Zipkid Redirecting to a non-framed site 20707 by: Srinivasan Ramakrishnan 20726 by: WILSON, Nick 20738 by: Srinivasan Ramakrishnan 20774 by: Daniel Convissor Globally runnable PHP script 20708 by: Srinivasan Ramakrishnan 20709 by: Matt McClanahan 20717 by: Philip Hallstrom 20743 by: Michael Kimsal Re: array_pad 20710 by: Dan Gibbs 20712 by: Dan Gibbs 20714 by: Zipkid Re: php-general Digest 16 Oct 2000 19:11:13 -0000 Issue 290 20713 by: Matthew Leingang Authentication (problem with headers) 20716 by: Mark Campbell compile error?!? 20718 by: Kurth Bemis 20735 by: Kurth Bemis newbie db question 20719 by: Matthew Mundy 20723 by: Opec Kemp ( Ozemail ) 20747 by: Mark Maggelet 20750 by: Matthew Mundy 20751 by: Opec Kemp ( Ozemail ) must be a better way 20720 by: Jerry Lake 20721 by: Jason Murray 20724 by: WILSON, Nick 20732 by: Brian T. Allen 20763 by: Maxim Maletsky 20764 by: Jason Murray 20766 by: Maxim Maletsky 20770 by: Jason Murray PHP 4 and PHP 3 in the same Apache 20722 by: Sergio Bruder Re: How to access variables in phpinfo()? 20725 by: idban secandri Re: File NOT locked. WHY ?? HELP PLEASE!!! 20727 by: idban secandri mysql_connect() error 20729 by: sannec27.eng.uab.edu 20730 by: Jason Murray Horde PHPLIB 20731 by: Maximo dumb question 20733 by: David Dahl 20736 by: Samantha Savvakis 20737 by: James Atkinson [PHP4] java applet not found when using php 20734 by: news.php.net Does PHP3 setcookie() function have a return value? 20739 by: Grant Walters searches 20740 by: LDL Enterprise 20761 by: Maxim Maletsky two ?s: '' vs ""; function to post form data 20744 by: Alan Tu 20771 by: Daniel Convissor 20773 by: Matt McClanahan 20775 by: Marc Antony Vose 20776 by: Philip Olson Input form strategy? 20745 by: Todd Cary 20787 by: Daniel Convissor Re: Beginner's attempt fails 20746 by: David Robley php news groups 20748 by: Paul O'Neil mysql error codes 20752 by: Scott Mebberson 20757 by: David Robley Safe Mode and auto_prepend 20753 by: Joel Alan Chornik Template Documentation 20754 by: William Lai 20755 by: Rasmus Lerdorf Re: random generation 20756 by: Maxim Maletsky Re: confirm subscribe to php-general@lists.php.net 20758 by: Mukul Sabharwal Re: time based execution 20759 by: Maxim Maletsky Com Port Access 20760 by: Chris Aitken Re: php3 MySQL------ is it necessary to convert all dates if I want to calculate ? 20762 by: David Robley Re: 2d array or? 20767 by: Daniel Convissor Re: What is max # variables a page/form can hold? 20768 by: Daniel Convissor Re: Calling text files -- HTML content management? 20769 by: Daniel Convissor Re: pb PHP / IMAP forward 20772 by: David Robley No Server Vars in PHP3 20777 by: Mukul Sabharwal Fakeing the address in the bar... 20778 by: Dallas Kropka 20779 by: Ashley M. Kirchner 20780 by: Matt McClanahan 20781 by: Maxim Maletsky 20782 by: Ali Ahmad H 20783 by: Maxim Maletsky 20784 by: Joseph H Blythe 20786 by: Maxim Maletsky 20790 by: Joseph H Blythe Python & PHP 20788 by: Maxim Maletsky 20789 by: Opec Kemp ( Ozemail ) 20791 by: Philip Olson Counters 20792 by: Floyd Ingram 20795 by: Cameron Brunner Com Port Access - Take 2 20793 by: Chris Aitken 20797 by: Matthias Endler imagecolortransparent 20794 by: Kdtc MySQL connect function 20796 by: Jack Dempsey Maximum Execution Time and pereg_replace 20798 by: Brent Charbonneau Forms?? 20799 by: Ivanoff Jari 20800 by: Joe Stump 20801 by: Randall Goguen 20802 by: hentis.twilyt.com PHP site to CDRom 20803 by: Andrea Resmini 20805 by: David Robley 20808 by: Maxim Maletsky 20810 by: David Robley Security question (newbe) 20804 by: Dallas Kropka 20806 by: Mukul Sabharwal Searching a pattern in a dynamically generated URL 20807 by: Aditya Chugh Re:Searching a pattern in a dynamically generated URL 20809 by: Aditya Chugh Administrivia: To subscribe to the digest, e-mail: php-general-digest-subscribe@lists.php.net To unsubscribe from the digest, e-mail: php-general-digest-unsubscribe@lists.php.net To post to the list, e-mail: php-general@lists.php.net ----------------------------------------------------------------------