Form Validation on Update Pages

I have form validation applied to a page that inserts a new record into the database and I have set it up so that if anything fails validation the information entered in the form persists in the fields through the validation - did this by following WA instructions to use the WA Validated Entries as the init val's in the for fields.

This works great when using a form to insert into the database, but I don't understand how to get the same effect with the form is instead updating the database. Now the init val's of the fields are set according to the recordset.

If I validate the entries and a validation fails all of the modified fields revert back to the recordset values.

Strategy for validating update forms? Thanks!

in the server validation behavior, set the failed redirect to the form page and pass a URL variable:
update.php?valid=false


you can create a ternary expression to use the validated entries value if the URL variable valid is equal to false, or use the recordset value if not, for example:

<?php echo(((isset($_GET['valid']) && $_GET['valid'] = "false"))?ValidatedField("update","firstName"):$row_recordsetName['FirstName']) ?>

Hey Jason,

can I perhaps use this, too?

<?php echo (isset($row_memberProfile['postcode'])?$row_memberProfile['postcode']:(ValidatedField("edit_390","postcode"))); ?>

why cant I use it the other way?

<?php echo (isset((ValidatedField("edit_390","postcode"))) ? (ValidatedField("edit_390","postcode")) : $row_memberProfile['postcode']); ?>

I need to delete some () but then I got that error

<?php echo (isset(ValidatedField("edit_390","postcode")) ? (ValidatedField("edit_390","postcode")) : $row_memberProfile['postcode']); ?>

Fatal error: Can't use function return value in write context in



cheers,
Denis

You should use the URL variable isset, not the recordset or validated entries, it wont work that way