I'm using mySQL. I tried yesterday with multiple different levels of query to get this working and never could. Even breaking down the initial query to 1/5th of it's original size I can't get it working. I might have to break down and ask one of my system guys to write a shell script for me.
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Brian Dumbledore [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 5:41 PM To: CF-Talk Subject: Re: Cfloop timing out. What database is it that you are using?? If SQL Server and you have access to it, and if it is possible and applicable in your case, the best thing to do would be to create and schedule a DTS package. > <cfsetting requesttimeout="largeValueInSeconds"> > > At the top of the page in question. Just set the value to how long > you would like to allow ColdFusion to run this template. With all the > usual caviots about system resources and such. > > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > --------- > | 1 | | > --------- Binary Soduko > | | | > --------- > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
