Jacques 0 Posted June 16, 2020 Report 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. Quote Link to post Share on other sites
Larry 428 Posted June 17, 2020 Report 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. Quote Link to post Share on other sites
Jacques 0 Posted June 17, 2020 Author Report 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 Quote Link to post Share on other sites
Larry 428 Posted June 19, 2020 Report Share Posted June 19, 2020 Not a problem. Glad you've got it figured out. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.