[PHP-DB] set NULL vaules in Access DB

[Silvia Mahiques]

        Hello,
I have some problems to put Null value in a field of a data base in Access.
This field is numeric type. When I submit the form, variable has $var='', I
set it $var=Null, but ODBC returns an error:

Warning: SQL error: [Microsoft][Controlador ODBC Microsoft Access] No
coinciden los tipos de datos en la expresi�n de criterios., SQL state 22005
in SQLExecDirect in c:\win\apache\htdocs\do_access_db.php4 on line 214


        Can anybody help me?

        Thanks

        Silvia Mahiques




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]