----- Original Message -----
Sent: Tuesday, April 23, 2002 8:47
AM
Subject: RE: [CFTALKTor] Access Query to
Excel Spread Sheet
First: CF queues up the page result until your
script execution is COMPLETE. (e.g. So that the cflocation command can
work).
This
means the browser does not receive the FIRST byte of the result until the LAST
byte of the result has been processed server side. You can override this
by using the CFFLUSH tag to push the queued up bytes to the
browser.
(Do
this
<HTML><BODY>Please wait while we process
your request...<CFFLUSH><!--- now do your big
query--->
)
Second: A browser will not start displaying a
table until ALL of the table has been received. Therefore, if you have a
LOT of records, and you want them to start displaying quickly, then break your
recordset up into multiple tables, eg every 100 records or so close the table
and then start the table again. The down side of this is your different
tables may not have the same column widths unless you use explicit column
width definitions.
If
you need sample code of this, let me know.
Terry Fielder
Network Engineer
Great Gulf Homes / Ashton
Woods Homes
[EMAIL PROTECTED]
Hi All,
I have problem with a query that I am doing in
access with CF. The query is returns a lot of records and
causes the browser (netscape 4.78 and the network security won't
upgrade!) to go "not responding" for a while then it produces the
query results. The query comes out as one table, they want to see all
the records in one page. Any suggestions on how to make this run
better so the users browser doesn't crash or give them the impression that
it has crashed?
Does having the whole query result in one table
slow things down?
Providing that the above is a problem that the
results are just to big. Can anyone tell me how convert my query
results in to an Excel Spread and produce a link that the can
download.
Thanks
Mike
