Hi,
The last two nights I have had a problem with some of our overnight batch type
processing scheduled jobs.
A few of them email their success when they have finished running using an
application variable in the "from" attribute of a cfmail eg
application.from_email_address.
This has worked fine for over a year except the last two nights. I am getting
an 'Parameter is not defined" type error indicating these variables don't exist.
The variable is created in the Application.cfm
<cfif NOT ISDEFINED("APPLICATION.FROM_EMAIL_ADDRESS")>
<!--- To avoid Emails from the app going to Spam\Trash, I am going to
use a real email address from the FROME param--->
<cfquery datasource="#DSN#" name="DEFAULT_FROM_EMAIL_ADDRESS">
SELECT sb_param_value_txt
FROM sb_system_params
WHERE sb_param_code = <cfqueryparam
cfsqltype="cf_sql_varchar" value="FROME">
</cfquery>
<cfif DEFAULT_FROM_EMAIL_ADDRESS.recordcount eq 1>
<cfset APPLICATION.FROM_EMAIL_ADDRESS =
lcase(DEFAULT_FROM_EMAIL_ADDRESS.sb_param_value_txt)>
<cfelse>
<!--- Set the from email address to appname --->
<cfset APPLICATION.FROM_EMAIL_ADDRESS = "AppName">
</cfif>
</cfif>
I can't understand why it would disappear.... It doesn't appear to happen
consistently.... multiple batch jobs use this set up, but not all of them fail.
Any thoughts?
CFMX 6.1
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
