Monday, March 12, 2012

Want to email a db record result

Greetings, I want to email a db record to an individual. The body of the email needs to contain the db fields. I want to separate each field by a line break "<BR>".

--Example:

First Name: John
Last Name: Doe
Home Phone: 503-234-2342
and soforth...

The code is probably simple but i cannot see the solution! It appears to me the the "<BR>" in the text attribute of the textbox is screwing things up. I've tried various way of single and double quotes...?

--Code:

<asp:TextBox runat="server" ID="Body" TextMode="MultiLine" Columns="55" Rows="10" Text=' <%# "Last Name: " + ds_LastVolunteer.FieldValue("LastName", Container) +<br> + "First Name: " + ds_LastVolunteer.FieldValue("FirstName", Container) %>'></asp:TextBox>

It should be <br /> and it should be in quotes, e.g. ...ds_LastVolunteer.FieldValue("LastName", Container) + "<br />First Name: " +...

However, with adding this to a textbox, it should be "\n", so ...ds_LastVolunteer.FieldValue("LastName", Container) + "\nFirst Name: " +...

-Damien


I agree with Damien, <br has to be with quotes but <br /> if the doctype isxhtml and <br> is just as fine if the doctype is4.01 transitional


That did it! Thank you very much.

0 comments:

Post a Comment