Could there be an issue with initialising not being done inside a lock?
Blair
On Wed, Apr 23, 2008 at 8:36 AM, Scott Thornton <
[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
