06 Aug 2017 20:22:06 Charles cruise posted:
I'm not sure if I am missing something or not, but I followed the video tutorial "Check if a Record Already Exists in Your Database" to add validation to see if a record already exists. I believe i have everything setup right, since it's so simple, but when I enter data that already exists, no message shows up.
Under DMXzone App Connect, for the form i have a dynamic event setup that resets the form on success entry into database. I also have a required validation rule for the text field setup.
Under DMXzone Server Connect I created a Validate Data after my database connection and before the Database Insert per video. However, after setting up and I click on validate options again, in the HTML5 Form Validator window that pops up, the expression field next to the name is blank. I double click on it and Dreamweavers file indicator windows pop up before it allows me to click on the dynamic button. I click on it, expand $_POST, and select my form field named "modelYear". In Field Properties I have "modelYear" listed next to Linked Field, validation rule is Does not exist in Database. Connection, table, column, message are filled it. When i enter a year that already exists, the message does not appear below as shown in video. If I enter a year that does not exist, the form gets reset and using phpmyadmin, i see the data added to the table.
Thank you in advance for your assistance.