Ian,
>
> Did you look at the example link  ??
>
I hadn't, but looked just now and it all looked just as I expected.

>
> Do you have any sample code I can look through to see how I would achieve
> this?
>
>
Sure - it nothing special though.... In fact here - off the top of my
head....

<!--- action page from the email address/birthday form --->
<CFQUERY name="getUser" datasource="mydsn">
   SELECT * FROM Users
   WHERE emailaddress = '#form.emailaddress#'
    AND BirthDate =
#CreateODBCDate(CreateDate(Form.BdayYear,Form.BdayMonth,Form.BdayDay))#
</CFQUERY>

<CFIF getUser.RecordCount>
    <!--- You can find a free password generator on the Devex part of the MM
site --->
    <CF_GeneratePassword OutValue="NewPassword">
    <CFMAIL TO="#getUser.emailAddress#" [EMAIL PROTECTED] Subject="New
Password">
     Someone requested a new password for your account on www.yoursite.com.

     Your new password is : #NewPassword#

      Please change this password in the "Change your details" section of
the site.
      http://www.yoursite.com/account/

      Thank you for using our site.

       User Account Admin
   </CFMAIL>
<CFELSE>
    Sorry.  An account with these details could not be found.  Please check
them and try again.
</CIF>

Hope this helps

Regards

Stephen
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to