At the top of the template, add:

<cfsetting requesttimeout="X">

X = seconds before timeout

-----Original Message-----
From: Randy Messer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 11, 2006 1:30 PM
To: CF-Talk
Subject: Timing Out Work Around

Client uploads Access Db, then script runs a qry to grab zip, loop thru  SQL
to find assoc. Dealer, it emails the dealer and then updates the Access.
Problem is it times out. I'm looping 50 records at a time and thought this
would cure it, but doesn't. The loops are using the original qry - would I
need to run a new qry for each time it loops through the 50?

Long day, appreciate any help out there.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240287
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to