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 "firstname.lastname@example.org";
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 email@example.com means that firstname.lastname@example.org will be emailed every time that page opens.