I've got to disagree Gary. There are times when you need a 4000 line web page of results and you do not want to chunk it up into 400 pages of 10 results each. Sometimes the queries that result in a 4000 line report can be on the slow side. Using CFFLUSH with the interval option puts way to much faith in the Gods and sheer luck. I personally can't see any situation where using a CFFLUSH with an interval would be a good thing. You should be just using a CFFLUSH, with no arguments and take control of where your code is being output and plan it logically. Like I said, there is no point trying to CFFLUSH half way through a table. It won't render. You have to put CFFLUSHes between tables and chunk your data up into separate tables. Just saying 'flush the page every second' may work, but it won't give you the best results, or may give no results at all if all your data is still in one table.
Regards Darren Tracey > -----Original Message----- > From: Gary Menzel [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 3 February 2004 10:04 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: cfflush inside cfloop > > > > Any recommendations for using cfflush inside cfloop ? > > If you want to output things during a loop (like little dots > to show it is > doing something) you only need ONE <cfflush> (with an > "interval" set - > check the CF documentation) somehwere before you want to have > the streamed > output happening. > > You don't specifically need to call <cfflush> inside the loop. > > However, it sounds as though you are wanting to output > something while the > <cfquery> is being executed, this isn't really possible. > > If you are looking for a more efficient way to get the data from the > database, you might like to look back at the posts earlier > this week by > Taco Fleur about restricting the amount of records returned > by a query > that can be used for paging. > > > Gary Menzel > Web Development Manager > IT Operations Brisbane -+- ABN AMRO Morgans Limited > Level 29, 123 Eagle Street BRISBANE QLD 4000 > PH: 07 333 44 828 FX: 07 3834 0828 > > > > If this communication is not intended for you and you are not > an authorised recipient of this email you are prohibited by > law from dealing with or relying on the email or any file > attachments. This prohibition includes reading, printing, > copying, re-transmitting, disseminating, storing or in any > other way dealing or acting in reliance on the information. > If you have received this email in error, we request you > contact ABN AMRO Morgans Limited immediately by returning the > email to [EMAIL PROTECTED] and destroy the original. > We will refund any reasonable costs associated with notifying > ABN AMRO Morgans. This email is confidential and may contain > privileged client information. ABN AMRO Morgans has taken > reasonable steps to ensure the accuracy and integrity of all > its communications, including electronic communications, but > accepts no liability for materials transmitted. Materials may > also be transmitted without the knowledge of ABN AMRO > Morgans. ABN AMRO Morgans Limited its directors and > employees do not accept liability for the results of any > actions taken or not on the basis of the information in this > report. ABN AMRO Morgans Limited and its associates hold or > may hold securities in the companies/trusts mentioned herein. > Any recommendation is made on the basis of our research of > the investment and may not suit the specific requirements of > clients. Assessments of suitability to an individual?s > portfolio can only be made after an examination of the > particular client?s investments, financial circumstances and > requirements. > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
