PHP 4.0 Bug #5456: ifx_fetch_row() error!
| From: | jtsai at geotempo dot com | Date: | Sat, 08 Jul 2000 10:27:26 +0000 |
| Subject: | PHP 4.0 Bug #5456: ifx_fetch_row() error! | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-23793@lists.php.net to get a copy of this message | ||
From: jtsai@geotempo.com
Operating system: redhead 6.1
PHP version: 4.0.0
PHP Bug Type: Other
Bug description: ifx_fetch_row() error!
I have using PHP4.0 whith Informix (IDS 7.3 Linux), and everything is fine.
only when use ifx_fetch_row() to retrieve multiple record with TEXT field(blob) from DB,
if some of the blob field is NULL, it will
couse the ifx_fetch_row() error exception: no memory !!
e.g.
mytable(field1 integer, field2 TEXT, field3 varchar(6))
select * from mytable
...
while(ifx_fetch_row())
==> if the result set include 10 records and
row2 ==> field2 is NULL and
row3 ==> field2 is NULL
when fetch row2 ==> no memory !! (error exception)
ps. the text process is set to:
ifx_textasvarchar(1);
ifx_byteasvarchar(1);
Please someone can fix it or tell me how to
solf this problem.
jackson Tsai