• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4360
  • Last Modified:

CF Try Catch Cold Fusion

We have this page that we are running nightly.  I can't get the email to fire off if there is an error..



<cfquery name ="GetBanners" datasource="FCdata">
SELECT     ID, StartDate, Weight
FROM         tTechCellBannerList
ORDER BY StartDate DESC
</cfquery>
 
<cftry>
<cfloop query="GetBanners">
<cfif DateFormat(GetBanners.StartDate,'short') EQ DateFormat(Now(),'short') >
<cfquery datasource="FCData" name="UpdateBanners">
Update tTechCellBannerList
SET 
Weight = 1
WHERE ID = #Get Banners.ID#
</cfquery>
</cfif>
</cfloop>
<cfcatch type = "Any">
 <cfmail to="webhelp@fmanet.org"
 from="Info@thefabricator.com"
 subject="Techcell Banner Update Status Error"
 type="html">
 #cfcatch.detail#
 </cfmail>
</cfcatch>
  
</cftry>

Open in new window

0
Albee_J
Asked:
Albee_J
1 Solution
 
_agx_Commented:
There's nothing wrong with the code.  It generates and error (and email) because of the space in the query name: #Get Banners.ID#.  Have you properly configured your mail server in the CF Administrator?  

But both queries should be inside the cftry/cfcatch  and you should be able to do the update in one query.  The exact syntax depends on your database and column type.






   <cfset today = createDate(year(now()), month(now()), day(now()))>
   <cfquery datasource="FCData" name="UpdateBanners">
      UPDATE   tTechCellBannerList
      SET    Weight = 1
      WHERE    StartDate >= <cfqueryparam value="#today#" cfsqltype="cf_sql_date">
      AND      StartDate < <cfqueryparam value="#dateAdd('d', 1, today)#" cfsqltype="cf_sql_date">
   </cfquery>

Open in new window

0
 
Albee_JAuthor Commented:
Great I will give that a shot and give you the update.

I put a space in   #Get Banners.ID# on purpose because I was trying to generate an error to trigger the email to be sent....
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now