Thanks, This looks really interesting and I am going to give it a try today.
Mario -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 7:29 PM To: CF-Talk Subject: Re: CFFLUSH and IE5.x - 6.0 Yes, by default, IE waits for the table to finish before it is rendered. However, you can change this behaviour by using the "table-layout: fixed" style to your table and optionally adding <col> tags. There's more information in MSDN: Go to http://msdn.microsoft.com/library/ and then Web Development -> HTML and Dynamic HTML -> SDK Documentation -> Reference -> Properties -> tableLayout. Many people do not realize that later versions of CF, by default, outputs content to the browser almost immediately. <CFFLUSH> is actually quite useless in most circumstances. ----- Original Message ----- From: "Ciliotta, Mario" <[EMAIL PROTECTED]> Date: Wednesday, July 9, 2003 5:14 pm Subject: CFFLUSH and IE5.x - 6.0 > Hi > > I was wondering if anyone has any experience with using cfflush > and IE. I have been trying to get the results of a query to start > flushing out to the screen but I have been unsuccessfully. The > query usually returns about 150-200 rows. I cleaned up the page > so that all the summing and totaling is now handled by the > database instead of CF (way fast page loading - but the users want > more). Basically the query will run and then I output the data to > the page. The data is displayed in a table for formatting > purposes but it never seems to flush. It looks like IE waits for > the table to finish - seems as though IE will not flush a > partially composed table?????? Just guessing. > > If anyone knows how to get CFFLUSH to work in this example that > would be great. > > Here is the code that I have so far -- Sorry it is a app that I > inherited from another group so some of the CF might not be the > best, but I'll clean it up after the flush issue. > > Thanks in advance, > > Mario > > Code example: > > <CFSETTING ENABLECFOUTPUTONLY="Yes"> > > <CFSET StartDate = #DATEFORMAT((form.txtFromDate),"yyyy/mm/dd")#> > <CFSET EndDate = #DATEFORMAT((form.txtToDate),"yyyy/mm/dd")#> > > <CFSET WhereC = "WHERE tblLobbyEntry.EntryDate Between > '#StartDate#' And '#EndDate#'"> > > <CFIF #form.div# IS NOT 0> > <CFSET WhereC = WhereC & " AND tblLobbyEntry.Division = > '#form.div#'"> <CFSET strDiv=#form.div#> > <CFELSE> > <CFSET strDiv='All Divisions'> > </CFIF> > > <CFIF #form.cboEmployee# IS NOT "N/A"> > <CFSET whereC = WhereC & " and tblLobbyEntry.globalID = > '#form.cboEmployee#'"></CFIF> > > <CFQUERY NAME="GetInfo" DATASOURCE="#app_datasource#" > USERNAME="#app_user#" PASSWORD="#app_passwd#"> > SELECT a.* > FROM (SELECT globalid, MAX(lname) lname, MAX(Fname) fname, > COUNT(*) total_cnt, > SUM(CASE WHEN registered = 0 THEN 1 ELSE 0 END) > unregistered, > SUM(CASE WHEN registered = 1 THEN 1 ELSE 0 END) > registered, tblLobbyEntry.Division, tblLobbyEntry.LName > + ', ' + tblLobbyEntry.FName Employee > FROM dbo.tblLobbyEntry > #preserveSingleQuotes(WhereC)# > GROUP BY globalid, lname, fname, division) a > WHERE Total_Cnt >= #form.cboVisits# > ORDER BY total_cnt, lname, fname > </CFQUERY> > <CFSETTING ENABLECFOUTPUTONLY="No"> > > <html> > <head> > <meta http-equiv = "Express" content = "-1"> > <META HTTP-EQUIV="Expires" CONTENT="Mon, 06 Jan 1990 00:00:01 GMT"> > <CFHEADER NAME="Pragma" VALUE="no-cache"> > <CFHEADER NAME="Expires" VALUE="Now()"> > <CFHEADER NAME="cache-control" VALUE="no-cache, no-store, must- > revalidate, max-age=0"> > <BASE TARGET="listing"> > </head> > > <LINK href="./script/2001_intranet_style.css" rel=stylesheet> > > <body> > > <table width="100%" border="1" cellspacing="0" cellpadding="2" > align="center" bordercolor="silver" > > <tr> > <td width="90%" id="ignore" class="RSHeader" colspan="9" > align="center"><b><cfoutput>No: of #strDiv# Overseas Employees > visiting London on #form.cboVisits# or more occasions between > #dateFormat(StartDate, "dd mmm yyyy")# and #dateFormat(EndDate, > "dd mmm yyyy")#: #GETINFO.RECORDCOUNT#</cfoutput></b></td> > </tr> > <tr> > <td width="100%" id="ignore" class="RSHeader" > align="center" colspan="13"><B>NUMBER OF COUNTRIES RETURNED: </B></TD> > </tr> > <tr bgcolor="GRAY"> > <td width="20%" id="ignore" class="RSHeader" > align="center"><b>Total Visits</b></td> > <td width="20%" id="ignore" class="RSHeader" > align="center"><b>Employee</b></td> > <td width="20%" id="ignore" class="RSHeader" > align="center"><b>Division</b></td> > <td width="20%" id="ignore" class="RSHeader" > align="center"><b>Registered Visits</b></td> > <td width="20%" id="ignore" class="RSHeader" > align="center"><b>Non Registered Visits</b></td> > </tr> > <CFFLUSH interval=5> > <CFOUTPUT QUERY="GetInfo"> > <tr> > <td width="7%" class="even" > align="left"><b>#total_cnt#</b></td> > <td width="20%" class="font2" align="left"> > #employee#</td> <td width="20%" class="font2" > align="left"> #division#</td> > <td width="20%" class="font2" align="left"> > #registered#</td> <td width="20%" class="font2" > align="Left"> #unregistered#</TD> > </tr> > </CFOUTPUT> > </table> > </body> > </html> > > This message is for the named person's use only. It may contain > sensitive and private proprietary or legally privileged > information. No confidentiality or privilege is waived or lost by > any mistransmission. If you are not the intended recipient, please > immediately delete it and all copies of it from your system, > destroy any hard copies of it and notify the sender. You must not, > directly or indirectly, use, disclose, distribute, print, or copy > any part of this message if you are not the intended recipient. > CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE > FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of > CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail > communications through its networks. Any views expressed in this > message are those of the individual sender, except where the > message states otherwise and the sender is authorized to state > them to be the views of any such entity. > Unless otherwise stated, any pricing information given in this > message is indicative only, is subject to change and does not > constitute an offer to deal at any price quoted. Any reference to > the terms of executed transactions should be treated as > preliminary only and subject to our formal written confirmation. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
