View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Is there a tutorial for validating a user in order to send them their password?

Thread began 1/03/2010 12:23 am by Stevebo | Last modified 1/14/2010 12:31 pm by Stevebo | 2783 views | 20 replies

Jason ByrnesWebAssist

Creating the secret answer is just a matter of adding two new fields to your users table (one for the questionID and one for the answer), and a new table for the secrete questions.

the new Table would be:
questionID - Primary Key
questionText - varchar

populate the secretquestions table with the questions that they should be al;lowed to choose from.

On the registration page, create a recorsdset to return the questions from the secretquestions table.

Add a select list to the registration form, set the select list to be dynamic, pull the values for the select list from the secretquestions recordset. set the Value to the questionID column and the label to the questionText column.

Add a new text box also for the user to type their answer.

in the insert record behavior, bind the questionID column of the user table to the select list, and the answer column to the answer text box.

Now on the New Password page, Create a recordset again to pull all the question from the secretquestions table. Create the select list again, make it dynamic, get the values from the secretquestions recordset, set the value to use the questionID column and the label to the questionText column.

add the answer text box as well.

create another recordset that filters the user table on the entered email address, the selected question and the answer.

Set the email password behavior trigger to only send if the lookup recordset is not empty. You can use the show region behavior to show an error message if the recordset is empty, you will need to modify the show region if statement so that it only shows the message if the recordset is empty and the form was submitted.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...