$sql = '......'.($var? $var:'NULL').'.....;'; Regards, Andrey ----- Original Message ----- From: "Silvia Mahiques" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- 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]