Open tables ? Close tables ? Huh ? Are you talking stuff like CREATE and DROP Temp tables ?
> Not at all, Andrew. > What I am saying is that CFFLUSH _is_ a suitable solution, (probably the = > only solution). > Your tables need to be split. Their _your_ tables, so you split them.=20 > No CF tag is going to dick around with your tables for you. > > This is how I'd do it. > > output page headers > cfflush > initialise a query_row_counter to 1 > start tables > loop though query > if (query_row_counter mod 10) is 0 > close tables > cfflush > start tables > end if > output query row > increment query_row_counter > end loop > close tables > > This will flush the page out after every 10 lines (or whatever value you = > put after the mod in the if at the beginning of the loop) > > Give it a try. Its not hard. Your users will thank you (well, they won't = > actually thank you. They never do that. But they may not complain as = > much!) > > Regards > Darren Tracey > > > -----Original Message----- > > From: Andrew Dickinson [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 3 February 2004 2:05 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] Re: cfflush inside cfloop > >=20 > >=20 > > I was looking for something which could show a fraction of=20 > > data at a time > > while loop processing continued i.e. rather than waiting for=20 > > a whole and > > heavy [age to load in one go. > >=20 > > What you guys appear to be saying is that CFFLUSH, or CFFLUSH=20 > > alone, is > > not a suitable solution, and the main reason is that CFFLUSH is not > > designed to split tables, which is what it would need to do=20 > > to accomplish > > what I had in mind. > >=20 > > > And yes, if what you are trying to output is a table then=20 > > you need a more > > > comprehensive solution. > > > I personally didn't find the explanation of what was wanted=20 > > clear enough > > > to be too specific about the solution. > >=20 > > > 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 > >=20 > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to=20 > > [EMAIL PROTECTED] > >=20 > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > > http://www.mxdu.com/ + 24-25 February, 2004 > >=20 --- 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
