set NULL vaules in Access DB
| From: | Silvia Mahiques | Date: | Wed, 28 Nov 2001 09:37:11 +0000 |
| Subject: | set NULL vaules in Access DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14643@lists.php.net to get a copy of this message | ||
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