Subject | Re: [firebird-support] Weird php and firebird problem, repeating values |
---|---|
Author | Fabio Gomes |
Post date | 2005-12-12T17:44:25Z |
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, so i never imagined that the problem would be so STUPID!
Btw.. thanx guys for you patience with a stupid newbie like me, you helped
me a lot, now i m gonna set ALL my fields as NULL by default.
Thanx a lot, now i can rest in peace :)
[Non-text portions of this message have been removed]
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, so i never imagined that the problem would be so STUPID!
Btw.. thanx guys for you patience with a stupid newbie like me, you helped
me a lot, now i m gonna set ALL my fields as NULL by default.
Thanx a lot, now i can rest in peace :)
[Non-text portions of this message have been removed]