www.hkvforums.com

Hi, how can I solve the following:
When i add data in another table, if the field is empty a "0" is added in the field "ph_envio", I don't want the zero to be added.

$MyResult = ew_Execute("INSERT INTO historical (ph_userlevel, ph_envio, ph_concep, ph_file) VALUES ('" . Security()->CurrentUserLevelName() ."', '".$rsnew["fe_envio"]."', '".$rsnew["fe_concep"]."', '".$rsnew["fe_file"]."')");

Thanks for the help.

Add this code before your code above:

if ( empty($rsnew["fe_envio"]) || $rsnew["fe_envio"] == "0") {
$rsnew["fe_envio"] = "";
}

Why it does not work ?

I did a test directly in the INSERT INTO; I put this value directly ->'test' in the field '".$rsnew["fe_envio"]."' and it does not work, continue adding zero "0".

$MyResult = ew_Execute("INSERT INTO historical (ph_userlevel, ph_envio, ph_concep, ph_file) VALUES ('" . Security()->CurrentUserLevelName() ."', 'test', '".$rsnew["fe_concep"]."', '".$rsnew["fe_file"]."')");

I have this code in a table called "f_executive" i tried it in, Row_Inserting and Row_Inserted and it does not work.

Then double check your table schema, probably default value of that field is "0", so that when you are inserting a record to the table, the value always set to "0" for the field.

1. Check your default table value (as mobhar's said).
2. Check your default value in Add section in field setup.
3. Loose this single quote '".$rsnew["fe_envio"]."' if your field is INT type.