Jacques Posted June 16, 2020 Share Posted June 16, 2020 Hi Larry, I want to update a user's data where the unique email will either be updated or not. Using the script as it stands, the email has to be updated for the script to execute successfully. Do you have any suggestions on how to approach this because I can't figure out for the life of me if it would be done with validation or a database query or a combination of both? Thank you. Link to comment Share on other sites More sharing options...
Larry Posted June 17, 2020 Share Posted June 17, 2020 Hey! If you're talking about Script 10.3, it doesn't require that the email be updated. It uses the form values to "update" the email address in the database, but the form value could very well be the same as the current value. Link to comment Share on other sites More sharing options...
Jacques Posted June 17, 2020 Author Share Posted June 17, 2020 (edited) Hi Larry, Please accept my apology for wasting your time. I got the query for checking for the unique email wrong as I left out the "!" when checking the email against the user_id. I fixed that and the query and script executes perfectly now. Sorry again, and thanks for your prompt response and excellent forum! Edited June 17, 2020 by Jacques Link to comment Share on other sites More sharing options...
Larry Posted June 19, 2020 Share Posted June 19, 2020 Not a problem. Glad you've got it figured out. Link to comment Share on other sites More sharing options...
Recommended Posts