Hi everyone --
Yet another simple problem. I have a database filled with two emails, and this
used to work, and now doesn't for some reason, and a form called srchasp.htm
with a textbox called Experience. How do I get emails from the database to
send anything I type in the textbox called Experience once I submit I found this on
the web
and now I can't find it again. The emails just don't get there...
Julia Green
<CFQUERY NAME="gilwayb" DATASOURCE="jgrn123" USERNAME="jgrn123" DBTYPE="ODBC"
PASSWORD="">
SELECT Email, LastName
FROM list
</CFQUERY>
<html>
<head>
<title>
Your Newsletter has been sent!</title>
</head>
<BODY bgcolor="#FFFFFF">
<h1>Your Newsletter has been sent out!</h1>
<br><br>
<a href="newsletter.htm"><FONT SIZE="4">BACK TO Newsletter page</A></FONT><BR><BR>
<CFSET ListSent = ''>
<CFLOOP QUERY="gilwayb">
<CFSET ThisEmail=Email>
<CFMAIL TO="#ThisEmail#"
FROM= "[EMAIL PROTECTED]"
SUBJECT= "Newsletter"
SERVER="www.juliagreen.com"
>
Thank you for subscribing to our newsletter!
#Form.Experience#
</cfmail>
<CFSET ListSent = ListSent & " #LastName#
mailto:#ThisEmail# " & CHR(13) &CHR(10) & CHR(13) &CHR(10)>
</CFLOOP>
Julia Computer Consulting
Web Design @ Reasonable Prices
Email: [EMAIL PROTECTED]
www.juliagreen.com
Phone: 617-926-3413
Cell: 617-596-6003
Fax: 1-617-812-8148
Julia Computer Consulting
Web Design @ Reasonable Prices
Email: [EMAIL PROTECTED]
www.juliagreen.com
Phone: 617-926-3413
Cell: 617-596-6003
Fax: 1-617-812-8148
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
