Solved

CF Try Catch  Cold Fusion

Posted on 2007-11-15
2
4,328 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
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 insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now