Here's mine:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>Forgot Password</TITLE>
</HEAD>
<!--- Define variables --->
<CFPARAM NAME="Posted" DEFAULT="No">
<!--- Insert this code on any page sending email --->
<CFSET tzStruct = GetTimeZoneInfo()>
<CFSET DateString =
"#DateFormat(Now(),'DDD, DD MMM YYYY')#"
& " #TimeFormat(Now(),'HH:mm:ss')#"
& " -"
& "#NumberFormat(tzStruct.utcHourOffset,'00')#"
& "00">
<!--- Get a list of employees from the database. --->
<CFQUERY NAME="GetEmployees" DATASOURCE="#application.datasource#">
SELECT PersonID,
PersonFirstName,
PersonLastName
FROM PersonTable
WHERE PersonActive = Yes
ORDER BY PersonLastName
</CFQUERY>
<!--- Has the form been submitted? --->
<CFIF ISDEFINED("Form.Person"
>
<CFSET POSTED = "Yes">
</CFIF>
<BODY>
<CFOUTPUT>
<TABLE>
<TR>
<TD><CFINCLUDE TEMPLATE="MenuTable.cfm"></TD>
</CFOUTPUT>
<TD CLASS="MainPage">
<!--- Insert main page info here. --->
<!--- If the form has been submited, insert the data and send success message. --->
<CFIF #POSTED# EQ "Yes">
<CFQUERY NAME="GetPassword"
DATASOURCE="#Application.Datasource#"
DBTYPE="ODBC">
SELECT *
FROM PersonTable
WHERE PersonID = '#Form.Person#'
</CFQUERY>
<!--- Send email --->
<CFMAIL TO="#GetPassword.PersonFirstName# #GetPassword.PersonLastName# <#GetPassword.PersonEmail#>"
FROM="Buzz"
SUBJECT="Your password"
TYPE="HTML">
<CFMAILPARAM NAME="Date" VALUE="#DateString#">
Your password is #GetPassword.PersonPassword#.<BR><BR>
You may login <A HREF="#Application.RootPath#Directory/EditUser.cfm">here</A> and change your password.
</CFMAIL>
<CFOUTPUT>
<H2>Thank you, #GetPassword.PersonFirstName#!</H2>
<H3>You will be receiving an email containing your password shortly.</H3>
</CFOUTPUT>
<!--- If the form has not been submitted, present the form. --->
<CFELSE>
<DIV ALIGN="center">
<BR><BR>
<CFOUTPUT>
<FORM ACTION="#cgi.script_name#" METHOD="POST" ENCTYPE="multipart/form-data"></CFOUTPUT>
<B>Please select your name from the list.</B><BR>
<SELECT NAME="Person">
<!--- Display every employee. --->
<CFOUTPUT QUERY="GetEmployees">
<OPTION VALUE="#PersonID#">#PersonFirstName# #PersonLastName#</OPTION>
</CFOUTPUT>
</SELECT>
<BR><BR>
<CFOUTPUT><INPUT TYPE="Submit" VALUE="Send Password">
</FORM>
</CFOUTPUT>
</DIV>
</CFIF>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
Calista :-X
Jedi Knight,
Champion of the Force
