Re: set NULL vaules in Access DB
| From: | Andrey Hristov | Date: | Wed, 28 Nov 2001 09:36:25 +0000 |
| Subject: | Re: set NULL vaules in Access DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14645@lists.php.net to get a copy of this message | ||
$sql = '......'.($var? $var:'NULL').'.....;';
Regards,
Andrey
----- Original Message -----
From: "Silvia Mahiques" <mahiques@posta.unizar.es>
To: <php-db@lists.php.net>
Sent: Wednesday, November 28, 2001 11:37 AM
Subject: [PHP-DB] set NULL vaules in Access DB
>
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>