Email autosend password from database

[Xylum]

Working on a somewhat complex function. I've found some related topics, but no
responses that can come close to helping. I've got a "forgot your password?"
page, with a username, challenge question, and challenge answer field that
query my database of registered users. When a user hits submit, I've got a
link to another page that says that an email has been sent with their password.
Only problem is, I don't know how to write that function, so an email with
their password has actually not been sent. Any suggestions or links for me to
follow?

[mxstu]

Compare the submitted answer with the value of challenge field and if it
matches, use CFMAIL to send the password information to their registered email
address and show the "email has been sent page". If their answer fails the
test, display an error. You probably would want to limit the number of retries
....

[SQLMenace]

If you use SQL server you could do this with xp_sendmail If you don't want to use CFMAIL

[sc]

hi, i've never send email from sql.. do you need any SMTP install in order
to use xp_sendmail on a sql server?


"SQLMenace" <webforumsuser@macromedia.com> wrote in message
news:dhr6fg$d1m$1@forums.macromedia.com...

> If you use SQL server you could do this with xp_sendmail If you don't want
> to use CFMAIL

[SQLMenace]

SQL Server does not wotk with SMTP (by default) to make it work with a SMTP server take a look at this

[url]http://sqldev.net/xp/xpsmtp.htm[/url]