yes to both. type is "database". I would like it to alert via email when the connection is slow
-----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 12:01 PM To: CF-Talk Subject: Re: connection timeout/failure is the catch around the cfquery specifically? have you specified a "type" for the catch? On 10/22/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > Is there anyway to hace CF send an email alert if a datasource connection > does not respond within a certain amount of seconds? > > I have a query that loads an image from another server and I'm using a > cfcatch, but it only reacts to a lost connection when the server fails. I > would like it to send an alert after a period of time when it does not > connect using a cfquery. > > Thx. > > Robert O. > HWW > > <CFQUERY NAME="hisname" DATASOURCE="oracle repository connection"> > SELECT name > from dateyy > where myday=to_char(sysdate,'DD') and mymon=to_char(sysdate,'MON') and > rights=0 > order by ranking,postings desc > </cfquery> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4