Value does not show in products_update.php page after double quotation mark

I am sure it might be an easy fix but I can’t figure out why any text or value that comes after a double quotation mark does not appear in the update page.

For example: I have a size field that should have inch sizes such as 12.50” x 2.5” included. Works great to include with the insert page and appears as entered in the DB. But as soon as I try to update the product - the update page shows 12.50 and cuts everything off after the double quotation (inch) sign.

I thought it either has to do with the field setting in the DB or with the code on the products_update.php page.

Here is the code on the products_update.php page for this field:


<div class="lineGroup">
<label for="ProductSize" class="sublabel" > Size:</label>
<div class="errorGroup"> <span id="ProductSize_Spry"> <span>
<input id="ProductSize" name="ProductSize" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("productsupdate","ProductSize"):"".$row_WADAproducts["ProductSize"]."")); ?>" class="formTextfield_Medium" tabindex="5" onBlur="hideServerError('ProductSize_ServerError');">
<?php
if (ValidatedField('productsupdate','productsupdate')) {
if ((strpos((",".ValidatedField("productsupdate","productsupdate").","), "," . "5" . ",") !== false || "5" == "")) {
if (!(false)) {
?>
<span class="serverInvalidState" id="ProductSize_ServerError">Please enter a value.</span>
<?php //WAFV_Conditional products_update.php productsupdate(5:)
}
}
}?>
<span class="textfieldInvalidFormatMsg">Invalid format.</span><span class="textfieldRequiredMsg">Please enter a value.</span> </span> </span> </div>
</div>

Any help is appreciated.

Thx.

AJ

in a form element, the value is enclosed by quotes, so the quote in the record is closing the value prematurly

change:
value="<?php echo((isset($_GET["invalid"])?ValidatedField("productsupdate","ProductSize"):"".$row_WADAproducts["ProductSize"]."")); ?>"

to:
value="<?php echo(str_replace("\", "&quot;", (isset($_GET["invalid"])?ValidatedField("productsupdate","ProductSize"):"".$row_WADAproducts["ProductSize"].""))); ?>"

Thanks Jason - I am getting an syntax error as soon as I change the code. Might there be a typo in the code?

sorry, value should be:
value="<?php echo(str_replace("\"", "&quot;", (isset($_GET["invalid"])?ValidatedField("productsupdate","ProductSize"):"".$row_WADAproducts["ProductSize"].""))); ?>"

Awesome. That did it. Thanks so much Jason.

Best,
AJ

you're welcome.

Sorry Jason - I was hoping you could also answer a follow up question:

How can I allow a fixed value that includes double quotation in a checkbox form? As an example, the following form includes the fixed value of 13.50 - 40 inches and I have to display it as follows:

<label>
<input type="checkbox" name="LeashLengthValue" value="13.50-40 in" id="LeashLengthValue_0">
</label>

I would prefer to have it entered as 13.5" - 40" but can not figure out how to do this with the double quotation.

Any hint is appreciated.

Thanks a lot.
Joerg

use the &quot; html entity:


value="13.50-40 &quot;"

Got this for the insert page. thanks a lot.

But I forgot to ask how am I going to check the value in the update or detail page then since the &quot is not recognized and the " not allowed.

<label>
<label class="checklabel" for="LeashLengthValue">
<input type="checkbox" name="LeashLengthValue" id="LeashLengthValue_0" value="13.50&quot;- 40&quot; (35-100cm)" class="formCheckboxField_Standard" <?php if (!(strcmp((isset($_GET["invalid"])?ValidatedField("productsupdate","Product_Hound_Leash_Length"):"".$row_WADAproducts["Product_Hound_Leash_Length"].""),"13.50&quot;- 40&quot; (35-100cm)"))) {echo "checked=\"checked\"";} ?>>
</label>

Thanks a lot.

Joerg

Yeah, to be honest, i don't recommend using quotes in your data, whether they are encoded or not they cause more problems then they are worth, like you have found for validation. there really is not a good way to do this and have it validate properly.