I just registered a new user using the username jbyrnes
The email I recieved was:
RE: Your sk8photos Login Information
UserName: jbyrnes
Password:
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 "webmaster@sk8photos.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 webmaster@sk8photos.com means that webmaster@sk8photos.com will be emailed every time that page opens.