RE: [CFTALKTor] Access Query to Excel Spread Sheet

Tue, 23 Apr 2002 06:31:25 -0700

<HTML><BODY>
<cfset variables.max_records_in_table = 100>
Please wait while your request is processed...
<cfflush>
<cfquery name="get_data" ...>
</cfquery>
 
<TABLE border=0 width="100%">
    <TR><TD width="40%">Field 1</TD><TD width="60%">Field 2</TD></TR>
    <cfset variables.records_in_table = 0>
    <cfoutput query="get_data">
        <cfif variables.records_in_table GT variables.max_records_in_table>
            </TABLE><TABLE border="0">
            <cfset variables.records_in_table = 0>
        </cfif>
        <TR>
            <TD width="40%">#get_data.field_1#</TD>
            <TD width="60%">#get_data.field_2#</TD>
        </TR>
        <cfset variables.records_in_table = variables.records_in_table + 1>
    </cfoutput>
</TABLE>
</BODY>
 
Instead of width in percentages you could use absolute, but I prefer percentages because then your table can grow/shrink to fit the browser depending on page width/screen resolution etc...
 
Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
 
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
Sent: Tuesday, April 23, 2002 9:00 AM
To: [EMAIL PROTECTED]
Subject: Re: [CFTALKTor] Access Query to Excel Spread Sheet

Thanks Terry
 
Yes I would like to see some sample code of this, it would be very helpful. 
 
Thanks
 
Mike
----- 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]

 
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
Sent: Tuesday, April 23, 2002 8:48 AM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] Access Query to Excel Spread Sheet

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

Reply via email to