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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jlim at natsoft dot com dot my
New email:
PHP Version: OS:

 

 [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: Thu Apr 25 23:01:29 2024 UTC