inserting username and password in body

Hi
Im trying to send email to database with login details but i get error in email.(when its received)
Username
Notice: Undefined variable: row_RecordsetEmail in /mnt/stor1-wc2-dfw1/423284/www.gentiva.com/web/content/webassist/email/templates/Blank.php on line 68
Password
Notice: Undefined variable: row_RecordsetEmail in /mnt/stor1-wc2-dfw1/423284/www.gentiva.com/web/content/webassist/email/templates/Blank.php on line 72


I tried to just use recordset in the body of the email.
Is this the wrong way?
Mike

This post has been deleted.

I'm not sure exactly what you did to resolve this issue, but in general an error like this means that the recordset has not been filtered properly as intended. If the recordset is empty or defined below the portion of the page that makes use of it you will get an error like this.

Eric
I havent resolved this issue.
I put this code in the default- blank.php page created by UE.
<?php echo $row_RecordsetEmail['UserEmail']; ?>
<?php echo $row_RecordsetEmail['UserPassword']; ?>

Do I include the record set on the blank.php page ?

Eric
Here are my email and blank.php files

To make use of these values you will need to put the recordset that you have on your email.php page on lines 39 to 43 into the blank.php page above the references to the bindings that come from this recordset. Also, it seems that you are not filtering the recordset for a particular user. If you are selecting the values from your users table without filtering it will select the first record from this table.

Eric
thanks can you explain how i filter the recordset using WA?

Do you make use of the User Registration Solution Pack or Security Assist for registering and logging in users? If so then you can really on the session variable for userID that is created when the user logs in.

If the user logs in a different way you will need to ensure that you are storing the id for the user in a session variabel. Once you have this session variable that holds the userID you can then filter a recordset anywhere on your site with this session variable.

To filter a recordset you need to open it up and at the bottom you will select to filter, then select the if or other unique identifier column that your variable holds a value for. Then you select that the filtered value is a session variable then just specify the name of the session variable.

If you have any further trouble with this post back with information about your user login and what values you are storing on login.

Eric,
Im actually using both..but the login was started with security assist. The login page is attached.
Thanks in advance
Mike

Ok, since you are using the WA Authenticate user server behavior you are storing the id for the logged in user in a session variable called UserID. To get the details of the user onto any page in the site you just need to add a recordset to that page. When you add the recordset to the page you need to filter it on this session variable value. To do this go into the filter area of the recordset interface and choose the id column, then choose to filter it on a session variable called UserID. You can then use the bindings for this recordset to put the values anywhere on the page by dragging and dropping them from the bindings panel.