On 2/28/07 2:37 PM, Damien McKenna wrote:
> I'm going to rearrange my code (its a file of functions) to see if there's
> something else tripping me up that I'm just not seeing.
OK, after moving the function from near the end to the top of the code it
still isn't making a difference.
Here's the entire file up to that point:
<!---<cfsilent>--->
<!--- notify the sponsor of the new sale --->
<!--- cheats and uses the session data --->
<cffunction name="notifyThem" returntype="boolean" output="true">
<cfset sponsor = customerView(session.cust.sponsor_id) />
<cfif IsStruct(sponsor) eq false>
1.
<cfreturn false />
</cfif>
<cfif IsEmail(sponsor.email) eq false>
2.
<cfreturn false />
</cfif>
<cfquery name="msg_details" datasource="#application.dsn#">
select
title,
content
from
content_misc_text
where
name = 'email_text'
</cfquery>
<cfif msg_details.recordCount neq 1>
3.
<cfreturn false />
</cfif>
<!--- prep the message headers --->
<cfset msg_from = "[EMAIL PROTECTED]" />
<cfset msg_to = """" & Replace(Replace(sponsor.name, "'", "", "all"),
'"', "", "all") & """ <" & sponsor.email & ">" />
<cfset msg_subj = msg_details.title />
<!--- prep the message body --->
<cfset msg_body = ReplaceNoCase(msg_details.content, "{NAME}", session.
cust.name, "all") />
<cfset msg_body = ReplaceNoCase(msg_body, "{PHONE}", session.cust.phone,
"all") />
<cfset msg_body = ReplaceNoCase(msg_body, "{LOCATION}",
session.cust.city & ", " & session.cust.state, "all") />
<cfmail to="#msg_to#" from="#msg_from#" subject="#msg_subj#"
charset="utf-8" type="html">#msg_body#</cfmail>
<cfreturn true />
</cffunction>
Note: yes, the cfsilent line is commented out. I had it in there to trim
down on whitespace but commented it when it wasn't working. Also, I added
in the displayed numbers to pinpoint where it was failing.
Thanks folks.
--
Damien McKenna - Web Developer [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include <stdjoke.h>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270986
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4