I just registered a new user using the username jbyrnes
The email I recieved was:
RE: Your sk8photos Login Information
It pulled the correct record, not sure why the password was not included, most likely, it is a problem with the registration page.
You should check the database directly to make sure passwords are being stored in the UserPassword column.
One thing I notice from your origianl code is that the EmailParam of the LostPassword recordset has a deffault value of "email@example.com";
the default value should be something that does not appear in the database like "-1". that way the recordset will be empty when the page first opens and no email will be sent.
Setting the default value to firstname.lastname@example.org means that email@example.com will be emailed every time that page opens.