Visitor ID in email confirmation

Hi

Having trouble seeing the best way for a visitor ID to appear in a registration confirmation email (using UE). The field I want to use it the automatic sequential primary ID.

Thanks

B

the DataAssist insert record will sore the ID value in a session variable.

If the registration page is using the data assisat insert record behavior, note the session name in the store as section. Use this session in your email.

The wizard will create the registration page using the Dreamweaver insert record behavior, but the "Introduction to SecurityAssist" tutorial on the Solution recipe section of the Security Assist support page has steps for changing this to use the data assist insert record behavior:
http://www.webassist.com/support/securityassist/

Hi Jason

It is using the data assisat insert record behavior, but I can't see the session name in the store as section for VisitorID.

I've attached the file to see if you can help.

This page is using the Dreamweaver Insert Record behavior, you must use the Data Assist insert record behavior for this.

Jason, you are a genius.

Glad to hear it is working.

Again in the email, how do I show a Country name instead of the Country ID?

this depends on a few factors.


where is the country id coming from?

Is is a select list that is showing the country name but has the country id for the value?

Does it need to pass the id for the value for other parts of the page to work?

If so, then you will need to create a lookup record set to filter the country id column on the value from the select list to return the country name, use the recordset value in the email.

If other parts of the page don't rely on the select list passing the country id, you can just set the select list to pass the country name instead.


I guess basically what I'm getting at is: if the only thing the page is doing is sending the email, the select list value doesn't need to be id, it can use the country name. If there is other processing, like storing in a database going on, you will need to evaluate whether the ID is needed or not. if it is needed, then you need to create a lookup recordset.

The email is a visitor registration confirmation for a website using eCart. I need to use a separate table for the countries to enable different zones for DHL shipping. So the two tables in use are the visitors table and the countries table. The countryID is a key column in the visitors table coming from the registration form which I need to link to it's country name value in the countries table.

Do I add a recordset while in the DW edit page in UE for the countries table and filter by the CountryID

or

Do I add a recordset that inner joins the visitors and countries table somewhere else?

In the main page, add a lookup recordset that will filter the country table on the countryid posted from the country select list.

Then in the email message, add a binding for the country name from the lookup recordset.