cfflush command

[alsjka]

is there any way to do a cfflush type command in version 4.5 coldfusion.. i have a really large query and would like to output a little data at a time.. any suggestions..?
thanks

 

[jymm]

couldn't you just control how much data you want to come across with the SQL like:

SELECT TOP 50 AccountNumber, AccountTerritory
FROM AccountTable

then just remove the TOP 50 when you know it is working --- I even build an if into some screens that will see if it is me testing and only give me the top 50... everyone else gets the whole thing dependant on the where clause...

 

[alsjka]

i need it for everyone else that will access the page. i have a few thousand items to return and it takes too long to query the items. and i have 3 queries going, i just wanted to give the user some data as the page renders. i tried the cfflush tag but i am running coldfusion 4.5 and it does not work..

thanks for the reply

 

[SidianConsulting]

There is no way to flush the contents of the http response buffer with ColdFusion versions prior to 5, unless you get into some fancy footwork with isapi filters, which I don't know much about.

How about using a next/previous interface? Displaying thousands of items on a page is usually annoying to users because 1, there is too much data to peruse and 2, it takes a bit for the query to run. Why not also implement a search? That way you have a next/previous full listing, and a search to return specific records as well.

-Tek