CFMail Errors

HashMan007 · Jun 16, 2002

Hi everybody;
I am trying to send out a bulk email using CF and access database. I have created a form where I can type my subject and message and when I click on send it should send messages to all the people in the database with email address. I am able to send out emails with now problems when I manually fill in the subject and the body portion of the message, but I get errors when it tell it to use:

"#Form.Subject#"
#Form.Message#. The error message follows my code. Please Help.

-----CODE-----
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<form name="form" method="post" action="">
<table width="75%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="4%"> </td>
<td width="13%"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Subject:</font></strong></td>
<td width="83%"><input name="Subject" type="text" id="Subject"></td>
</tr>
<tr>
<td> </td>
<td><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Message</font></strong></td>
<td><textarea name="Message" cols="60" rows="10" id="Message"></textarea></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="SEND!"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>
<cfquery name="get_email" datasource="Unique_support" dbtype="ODBC">
SELECT *
FROM support
WHERE email > '0'</cfquery>
<cfmail to="#email#" from="info@hc.net" subject="#Form.Subject#" query="get_email">
</cfmail>

---ERROR----
Error Diagnostic Information
SUBJECT

The attribute value is an invalid expression: An error has occurred while processing the expression:

#Form.Subject#

Error near line 1, column 3.

-----------------------------------------------------------

Error resolving parameter FORM.SUBJECT

The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.

The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (36:1) to (36:101).

Date/Time: 06/16/02 16:40:03
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

Sarky78 · Jun 17, 2002

You have got a form that does not submit to anything. what you need to do is to sumit the form to another page or the same one and check for a submission, but for ease it is easier to submit to another page for now.

your form should look like this:

<form name="form" method="post" action="yoursecondpage.cfm">

</form>

now on you second page you can put your cfquery and your cfmail tag as they are and this should then work.

so your second page will look like


<cfquery name="get_email" datasource="Unique_support" dbtype="ODBC">
SELECT *
FROM support
WHERE email > '0'
</cfquery>

<cfmail to="#email#" from="info@hc.net" subject="#Form.Subject#" query="get_email">
</cfmail>



the reason that this worked before when it was hardcoded was because it was not looking for variables that were defined in code/form submission, because you then moved to supply that information via a form this is what broke it

hope this helps

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

CFMail Errors

HashMan007

IS-IT--Management

Sarky78

Programmer

Similar threads

Part and Inventory Search

Sponsor