php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #6831 COM does not support variant type 1 (NULL)
Submitted: 2000-09-21 11:06 UTC Modified: 2001-01-30 19:04 UTC
From: jlim at natsoft dot com dot my Assigned: phanto (profile)
Status: Closed Package: COM related
PHP Version: 4.0.2 OS: Win98
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
24 + 13 = ?
Subscribe to this entry?

 
 [2000-09-21 11:06 UTC] jlim at natsoft dot com dot my
Currently, COM does not support variant type 1. This is type NULL.

This should be easy to fix as we can make it equivalent to false. Does PHP support null as a constant?

The bug can be replicated by accessing a database with nulls in the records using ADO.

<?
        $dbc = new COM("ADODB.Connection");
        $dbc->open ("driver={Microsoft Access Driver (*.mdb)};dbq=d:/test/DB/guestbook.mdb;uid=Admin");
        $rs = $dbc->Execute("select * from guestbook");
        $i = 0;
        while (!$rs->EOF) {
                $i += 1;
                $fld0 = $rs->Fields(0);
                $fld1 = $rs->Fields(1);
                $fld2 = $rs->Fields(2);
                print "$fld0->value $fld1->value $fld2->value<BR>";
                $rs->MoveNext();
        }
        $rs->Close();
?>

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-12-18 04:36 UTC] jlim at natsoft dot com dot my
Here's hoping for a quick fix :-) PHP 4.03pl1 also exhibits the above bug.

Just tested COM again and discovered variant type 6 (currency) is not supported either. 

Thanks again. 
 [2001-01-29 17:21 UTC] phanto@php.net
working on it
 [2001-01-30 19:04 UTC] phanto@php.net
fixed in cvs

use is_null() to check if the returned value is NULL;
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Apr 20 06:01:28 2024 UTC