Need to ensure a product has a minimum weight

In the admin page products_insert.php I have attempted to amend the weight text box to have a minimum weight of 0.01kg, but it breaks it's link to the DB when I change it.

So I have:

<input name="ProductWeight" type="text" id="ProductWeight" onBlur="" value="<?php echo(isset($_SESSION["WAVT_ProductsInsert_Errors"])?ValidatedField("ProductsInsert","ProductWeight"):"") ?>" size="32" />

and I m trying and have tried numerous ways of trying to post 0.01 without breaking the code for the insert or validation.

I've tried adding 0.01 to the DB column as a default value if the weight text box is left empty, but the DB shows -1.00.

Any thoughts?

Thanks.

try adding this code at line 1 of the product insert page:

<?php if(isset($_POST["ProductWeight"]) && floatval($_POST["ProductWeight"]) < 0.01) $_POST["ProductWeight"] = 0.01; ?>

No, that didn't work either!

I also tried:


<?php if(isset($_POST["ProductWeight"]) && floatval($_POST["ProductWeight"]) = "") $_POST["ProductWeight"] = "0.01"; ?>


and


<?php if(isset($_POST["ProductWeight"]) && floatval($_POST["ProductWeight"]) == '') $_POST["ProductWeight"] = 0.01; ?>



and


<?php if(isset($_POST["ProductWeight"]) && floatval($_POST["ProductWeight"]) == NULL) $_POST["ProductWeight"] = 0.01; ?>

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Just as a test maybe try changing the (and) && operator to the (or) || operrator (Just try it and see if it works...)

the check in my original code is to make sure that the Weight is set, AND that it is below 0.01

if you use the or separator, you will end up with an undefined index warning on page load if you set the error reporting level to show warnings.

the warning will happen because the weight variable wont have a value, using the or seperator will cause it to look at the second condition, but the variable doesn't exist yet.

I decided to move the weight text box to the first spry panel and make it a required value. That way the user knows they have to enter a value.