Developer Toolbox SendMail issue

[ianraba]

Hi all
I need to show the name of a chosen option that is from a dynamically
generated dropdown in an input form.
These input details are emailed.
All this works but I get the integer value of the foreign key not the name
I understand the I need to set a new recordset filtered by the posted value
from the form but for the life of me I cannot get the name from the foreign
keyed table to show in the received email???
Can someone explain how to do this please as its driving me potty!

[ChrisBank]

Is the form posting back to the server or is the submit button set to send the
e-mail? If your posting back to the server, you can making a simple page where
the body content is what you want in the e-mail.

That should make it easier to debug. Once you have the page generating the
text you want, if should be easy to get the e-mail to use the same text.

Hope the helps,
Chris

[geschenk]

Hi Ian,

>>

I understand the I need to set a new recordset filtered by the posted value
from the form

>>

it seems that the email body contains a reference to the form value, like
(ADDT "dynamic data" format now) {POST.fieldname} and not the value
derived from the new SELECT name FROM table WHERE user_id =
dropdown_fieldname - recordset ?

[geschenk]

Hi Chris,

I think that he?s using ADDT?s "send email" feature -- are you, Ian ?