Setting the default value of the form field to be a recordset entry AND the validated entry on an UPDATE form.

I have an UPDATE form that takes values from a recordset to populate the default values for each form field. However, if a user completes the form, submits, and the validation fails I'd like the default value to be the validated entries just submitted.

So, at the moment, the value is:
value="<?php echo($rsEDITNEWS->getColumnVal("njstitle")); ?>"

And in the INSERT form the value is:
value="<?php echo(ValidatedField("addnews_166","formTITLE")) ?>"

Is there a way to combine the two so that it first displays the recordset value but then, on submit and validation, the validated entry?

Thank you.
NJ

I'd add a url parameter to the failed redirect for the Server Validations.. so that if the validations fail it goes to your page like: addnews.php?valid=false

Then you can look for that url parameter when determining what value to default like this:

value=""<?php echo(isset($_GET['valid'])?ValidatedField("addnews_166","formTITLE"):$rsEDITNEWS->getColumnVal("njstitle")) ?>

Just created the Edit News page and when you insert a second Validation Show If, it wipes the first Validation Show If and jumps the code for that up into the head section! Check Line 43 of the attached.

This was happening with my Add News form too.

There is clearly a bug here which I hope you can sort for future releases. For now, as this is a time sensitive project, I'll need to manually repair it which removes the usefulness (point) of the extension entirely. So frustrating. :(

Originally Said By: Ray Borduin

  I'd add a url parameter to the failed redirect for the Server Validations.. so that if the validations fail it goes to your page like: addnews.php?valid=false

Then you can look for that url parameter when determining what value to default like this:

value=""<?php echo(isset($_GET['valid')?ValidatedField("addnews_166","formTITLE"):$rsEDITNEWS->getColumnVal("njstitle")) ?>  

Syntax error with that:

<input name="formTITLE" type="text" autofocus required class="form-control" id="formTITLE" placeholder="Please enter your name..." value="<?php echo(isset($_GET['valid')?ValidatedField("editnews_302","formTITLE"):$rsEDITNEWS->getColumnVal("njstitle")) ?>" size="20" maxlength="100">

Fix...

This...
<?php echo(isset($_GET['valid')?ValidatedField("editnews_302","formTITLE"):$rsEDITNEWS->getColumnVal("njstitle")) ?>

Should be...
<?php echo(isset($_GET['valid'])?ValidatedField("editnews_302","formTITLE"):$rsEDITNEWS->getColumnVal("njstitle")) ?>

Will try that on the site and report back.

That works, but I have an HTML Editor field whose initial value is defined as:

$CKEditor_initialValue = "".($rsEDITNEWS->getColumnVal("njtext")) ."";

How do I edit this so that it incorporates what I'm trying to do above? To display the recordset field default value initially but then the validated form value upon submit & failure of the validation?

Thank you Ray. Is Jason on holiday?
NJ

The same exact syntax:

$CKEditor_initialValue = "".(isset($_GET['valid'])?ValidatedField("editnews_302","your_editor_field_name_goes_here"):$rsEDITNEWS->getColumnVal("njtext"))  ."";