Jump to content
Larry Ullman's Book Forums

Recommended Posts

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

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

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 by Jacques
Link to comment
Share on other sites

 Share

×
×
  • Create New...