Right now I have a page set up that inserts a record into a DB that a user enterd. I have it set up to take them to another page that shows the the information that they entered. but I also have a cfmail tag that e-mails the same information to their e-mail. the only problem is when it goes to their email it doesn't show up the way I want it to. I want it to be inside of a table but when it shows up in their account it just shows the html tags. the only email client that shows it how I want it to display is hotmail. in gmail and and other accounts it just shows the HTML code.
here is my code
<cflock name="NewRecordInsert" type="exclusive" timeout="30">
<cftransaction>
<cfquery name="RecordInsert" datasource="Rumors_Forms">
INSERT INTO Bus (Name, Req_Date, Req_Time, Address, Email, PhoneNumber, Reason)
Values('#form.Name#', '#form.Month#/#form.Day#/#form.Year#' ,'#form.Req_Time#','#form.Address#','#form.Email#','#form.PhoneNumber#','#form.Reason#')
</cfquery>
<cfquery name="GetPK" datasource="Rumors_Forms">
SELECT Max(ID) AS MaxID
FROM Bus
</cfquery>
</cftransaction>
</cflock>
<cfquery name="GetRecord" datasource="Rumors_Forms">
SELECT ID, Name, Req_Date, Req_Time, Address, Email, PhoneNumber, Reason
FROM Bus
WHERE ID = #GetPK.MaxID#
</cfquery>
<cfmail query="GetRecord"
from="donotreply@rumorssportsbar.com"
to="#form.Email#"
bcc="ericstauss@gmail.com"
subject="Bus Reservation">
<html>
Here is your information that you entered
<table border="1" cellpadding="0">
<tr>
<th>Confirmation Number</th>
<th>Name</th>
<th>Date</th>
<th>Time</th>
<th>Address</th>
<th>E-mail</th>
<th>Phone Number</th>
<th>Purpose of Rental</th>
</tr>
<cfoutput>
<tr>
<td>#ID#</td>
<td>#Name#</td>
<td>#Req_Date#</td>
<td>#Req_Time#</td>
<td>#Address#</td>
<td>#Email#</td>
<td>#PhoneNumber#</td>
<td>#Reason#</td>
</tr>
</cfoutput>
</table>
Do not loose your confirmation number as you will need to to get the bus, you can also edit your settings with the number
</html></cfmail>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Rumors Bar & Grill | Review Entry</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
th{
background-color: #888888;
}
td {
background-color: #CoCoCo;
}
</style>
</head>
<body>
<div id="page">
<div id="header"><img src="Images/top3.jpg"></div>
<div id="nav" bordercolor="ffffff"> <cfinclude template="navigation.cfm"> </div>
<div id="content" valign="top">
<br>
<table border="1" cellpadding="0">
<h2>The Bus has been reserverd!!</h2>
<h3>Here are the details...</h3>
<tr>
<th>Confirmation Number</th>
<th>Name</th>
<th>Date</th>
<th>Time</th>
<th>Address</th>
<th>E-mail</th>
<th>Phone Number</th>
<th>Purpose of Rental</th>
</tr>
<cfoutput query="GetRecord">
<tr>
<td>#ID#</td>
<td>#Name#</td>
<td>#Req_Date#</td>
<td>#Req_Time#</td>
<td>#Address#</td>
<td>#Email#</td>
<td>#PhoneNumber#</td>
<td>#Reason#</td>
</tr>
</cfoutput>
</table>
</div>
<div id="right" valign="top">and here is extra, maybe an ad or something</div>
<!--<div id="footer">copyright and what not</div>-->
</div>
</body>
</html>
