Yes...by the time if fails its a bit too late -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 12:23 PM To: CF-Talk Subject: Re: connection timeout/failure
ah... so just to clarify... you're not looking for an alert message/email on a connection/query failure... but when the connection/query succeeds and takes greater than (a specified period of time) to do so? On 10/22/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > 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> > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4