Re: [firebird-support] Weird php and firebird problem, repeating values
Author
Martijn Tonies
Post date
2005-12-12T18:05:02Z
----- Original Message -----
From: "Fabio Gomes" <fabioxgn@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, December 12, 2005 6:44 PM
Subject: Re: [firebird-support] Weird php and firebird problem, repeating
values
> OMG!
>
> Finally after fighting agains this thing the whole day.. i found the
STUPID
> problem.
>
> All those fields that were repeating, had something in comon, they werent
> NULL, they where BLANK, so i did this:
>
> UPDATE CLIENTES SET CLI_LIM_CREDITO = NULL WHERE CLI_LIM_CREDITO ='';
> UPDATE CLIENTES SET CLI_OBS = NULL WHERE CLI_OBS ='';
> UPDATE CLIENTES SET CLI_CEP = NULL WHERE CLI_CEP ='';
> UPDATE CLIENTES SET CLI_CNPJ_CPF = NULL WHERE CLI_CNPJ_CPF ='';
> UPDATE CLIENTES SET CLI_IE_RG = NULL WHERE CLI_IE_RG ='';
> UPDATE CLIENTES SET CLI_DDD = NULL WHERE CLI_DDD ='';
> UPDATE CLIENTES SET CLI_TELEFONE = NULL WHERE CLI_TELEFONE ='';
> UPDATE CLIENTES SET CLI_CELULAR = NULL WHERE CLI_CELULAR ='';
>
> Then i ran they script again... and now everything is fine, i never think
> that it could be the problem, as am used to work with mysql, and in mysql
> blank = null,