emptying / zeroing a column

Hey Ray

In the backend on the product_update page I have a drop down field (SpecialOffer) (yes/no) to toggle on / off an input field (SpecialOfferOldPrice) to add a value that gives a discount to that product

The problem I am having is that if I have set the drop down to Yes (1) and added a value, eg £5.00 if I then go back and set it to no (0) the input field SpecialOfferOldPrice retains the 5 discount - how do I go about emptying or adding 0 to SpecialOfferOldPrice when SpecialOffer is set to 0 (no)?

Page attached if needed

Cheers

Jamie

You can change the value to use when blank in the server behavior for each column. This one is set to "blank", but you can update it to use "zero". That field probably doesn't accept a blank value since it is numeric.

I have tried that

$UpdateQuery->bindColumn("SpecialOfferOldPrice", "s", "".((isset($_POST["SpecialOfferOldPrice"]))?str_replace(array("£","%",),"",($_POST["SpecialOfferOldPrice"])):"")  ."", "WA_ZERO");

but that doesnt make that col 0 or blank. I guess the problem is that the column has a value in it from when the specialoffer was set , when you set the specialoffer to off, the SpecialOfferOldPrice still has a value in it and thats the value am trying to remove or zero

I see... then you just have to use the toggle in the value comparison like:

$UpdateQuery->bindColumn("SpecialOfferOldPrice", "s", "".((isset($_POST["SpecialOffer"]))?str_replace(array("£","%",),"",($_POST["SpecialOfferOldPrice"])):"")  ."", "WA_ZERO");

that isnt zeroing the column SpecialOfferOldPrice wehn SpecialOffer is toggled to 0 ('no')

Maybe try:

$UpdateQuery->bindColumn("SpecialOfferOldPrice", "s", "".(isset($_POST["SpecialOffer"])?str_replace(array("£","%",),"",($_POST["SpecialOfferOldPrice"])):"0")  ."", "WA_ZERO");

sorry, still not zeroing

I didn't realize you were using a select list and not a checkbox. In that case, since your "no" value in the select list has a value of zero the correct code would be:

$UpdateQuery->bindColumn("SpecialOfferOldPrice", "s", "".($_POST["SpecialOffer"]?str_replace(array("£","%",),"",($_POST["SpecialOfferOldPrice"])):"0")  ."", "WA_ZERO");