MDB2 - Text & BLOB return stream

[jakenoble]

Hi

Suddenly some of my fields of type text or blob are returning a resource #id.

If I do a var_dump on this resource it says it is 'of type stream'.

Any ideas how I can stop this happening, or how I can read the data out of the stream?

Thanks

Jake

[mark]

http://pear.php.net/manual/en/package.database.mdb2.intro-fetch.php, almost at the end of the page

[jakenoble]

Thanks for the info.Now I can get the data out in a useful fashion.

But why is this happening? I have been using binary text fields since I started coding this project, many weeks ago. Why have I only just come across this? All other attempts to access the data has given me a simple string.

Thanks, Jake

[mark]

What are "all other attempts"? Did you use MDB2 before? IIRC MDB2 does this "stream way" every time, while other abstraction layers return the contents of BLOBs/CLOBs just as every field, e.g. like a simple string.

[jakenoble]

Yes I have used MDB2 on several other pages to access the same field in the same table. The other uses all have returned a simple string.

I have not seen or used IIRC MDB2 anywhere.

The only difference 'I think' is that the stream version returns every row in the table using query(), all other uses of this table return just one row using getRow().