Solved

CF Try Catch  Cold Fusion

Posted on 2007-11-15
2
4,347 Views
Last Modified: 2013-12-16
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
Comment
Question by:Albee_J
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 20290709
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
 

Author Comment

by:Albee_J
ID: 20290840
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question