How do I use chunks for nText fields?

From: Date: Thu, 22 Mar 2007 15:09:04 +0000
Subject: How do I use chunks for nText fields?
Groups: php.db 
Request: Send a blank email to php-db+get-43320@lists.php.net to get a copy of this message
Hi, I've got a PHP 5 based website, talking to a MS SQL server database, using odbc_exec() and related methods. Some of the database fields are type nText, and return only part of the field value plus a pointer to the next part. My database guy pointed to a Microsoft example of how to deal with in VB using the "GetChunk" method within a while loop: http://msdn2.microsoft.com/en-us/library/aa905922(SQL.80).aspx I have two problems with this approach: 1) It seems a rather awkward way to do it 2) I can't find any documentation describing how to do it in PHP Can anyone tell me what I need in order to get the whole value of the field out? (I haven't been able to subscribe to php-db, so please CC me.) Cheers, Dave. -- David Balch. | Señor web developer. T: +44 (0)1865 280979 | Technology-Assisted Lifelong Learning. F: +44 (0)1865 280982 | University of Oxford. E: david.balch@conted.ox.ac.uk

« previous php.db (#43320) next »