How do I use chunks for nText fields?
| From: | David Balch | 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