I was very interested in this also, so I jumped right on this yesterday when I saw it...a little forewarning: it definitely works, but it still outputs in "chunks" and if you are nesting tables, it won't output inner table rows until the inner table is complete. So, for us at least (we use layouts heavily), it still isn't production worthy, unless we create a separate page for the flushes, which we do anyway...definitely good to know it's there, but not quite a end all, be all solution for cfflush->
Tyler -----Original Message----- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 9:36 AM To: CF-Talk Subject: RE: CFFLUSH and IE5.x - 6.0 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
