Re: READTEXT - Returning large text

look at your php ini file in the odbc section is a limit default = 4096. Set it to 0 for passthrough and try again. joe James Crowley wrote: > > 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 > > ---------------------------------------------------------------------- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net