Oh, so by "splitting tables", you meant splitting the physical display tables, not the database (SQL) tables. Right, that makes it a bit clearer.
> HTML tables.. > > Taco Fleur > 07 3535 5072 > Blog: http://www.tacofleur.com/index/blog/ > Methodology: http://www.tacofleur.com/index/methodology/ > Tell me and I will forget > Show me and I will remember > Teach me and I will learn > > > -----Original Message----- > From: Andrew Dickinson [mailto:[EMAIL PROTECTED] > Sent: Thursday, 5 February 2004 8:08 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: cfflush inside cfloop > > > 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 =3D > > only solution). > > Your tables need to be split. Their _your_ tables, so you split = > them.=3D20 > > No CF tag is going to dick around with your tables for you. > >=20 > > This is how I'd do it. > >=20 > > 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 > >=20 > > This will flush the page out after every 10 lines (or whatever value = > you =3D > > put after the mod in the if at the beginning of the loop) > >=20 > > Give it a try. Its not hard. Your users will thank you (well, they = > won't =3D > > actually thank you. They never do that. But they may not complain as = > =3D > > much!) > >=20 > > Regards > > Darren Tracey > >=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
