field being inserted as 0 instead of NULL

[Guest]

This isn't really for a contribution but I think this may be the most relevant forum .

 

categories.php:

$sql_data_array = array('products_quantity' => tep_db_prepare_input($_POST['products_quantity']),

                                'products_model' => tep_db_prepare_input($_POST['products_model']),
                                 'products_image' => $products_image,
                                  'products_price_network' => tep_db_prepare_input($products_price_network),
                                  'products_date_available' => $products_date_available,
                                 'products_weight' => tep_db_prepare_input($_POST['products_weight']),
                                 'products_status' => tep_db_prepare_input($_POST['products_status']),
                                 'products_status_network' => tep_db_prepare_input($_POST['products_status_network']),
                                 'products_tax_class_id' => tep_db_prepare_input($_POST['products_tax_class_id']),
                                 'manufacturers_id' => tep_db_prepare_input($_POST['manufacturers_id']),
                                 'per_item_shipping'=> tep_db_prepare_input($_POST['products_per_item_shipping'])
}
                           tep_db_perform(TABLE_PRODUCTS, $sql_data_array);

The concern is 'per_item_shipping' => null . For some reason even explicity setting this to null gets it inserted into the db as 0 (field is a double, set to NULL for default). This makes me assume that somewhere NULL is being converted into a string but I'm not sure where this is happening.

 

If anyone could shed some light on what might be occuring that would be much appreciated.

Cheers,

 

- Marc

[IndiaStarker 0]

Hi,

I have a similar problem where NULL is not being written to the database but a double 0.000 instead.

Does somebody know what to do to assign NULL to a field with tep_db_perform?

 

Example :

$echeances_value1 = NULL;
...
$sql_data_array = array(...
								'echeances_value1' => $echeances_value1,
								...

 

I also tried,

$echeances_value1 = '';

and

$echeances_value1 = "";

and even

$sql_data_array = array(...
								'echeances_value1' => NULL,

but the database alsways gets 0.000

 

Perhaps one must modify tep_db_perform :-( ?

-i.

[IndiaStarker 0]

Perhaps one must modify tep_db_perform :-( ?

Yes. Solved for me. MindVerveMedia's solution works great.

-i