Problems testing an ODBC field with is_null
Posted: Wed May 28, 2003 5:03 pm
(PHP 4.3.1 / MS-PWS / W98SE / Access2000 through ODBC)
I'm having a problem when I try to verify if an odbc field from an SQL query is null.
I've tried to test it whith 'is_null(odbc_result(.....' or to assign the field value to a variable and test the variable with 'isset'. The field is null in my DB but it is a 'boolean(false)' according with PHP (!?).
Is this something known with ODBC/Access? Is there some kind of php.ini configuration I have to alter to let PHP read the null values as real NULLs?
Any help will be really appreciated. Thanks in advance!!
I'm having a problem when I try to verify if an odbc field from an SQL query is null.
I've tried to test it whith 'is_null(odbc_result(.....' or to assign the field value to a variable and test the variable with 'isset'. The field is null in my DB but it is a 'boolean(false)' according with PHP (!?).
Is this something known with ODBC/Access? Is there some kind of php.ini configuration I have to alter to let PHP read the null values as real NULLs?
Any help will be really appreciated. Thanks in advance!!