Thanks Ben, I'll give that I try and see if it works.
Mario -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 7:31 PM To: CF-Talk Subject: RE: CFFLUSH and IE5.x - 6.0 In my experience, IE will display a partially defined table, as long as it knows how many columns. You may have to define column widths, but I don't think so. However, IE doesn't start displaying until it has about 1K of data. When we need to start flushing even when there's not much data, we put a big comment (My boss uses the first few pages of Anna Karinnina) at the top of the page then flush /that/ first. That way, IE is tricked into thinking it has a whole bunch of stuff to display. Stupid IE. :-\ -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -----Original Message----- : From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] : Sent: Wednesday, July 09, 2003 7:15 PM : To: CF-Talk : 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"><a : href="fsa_details.cfm?v=a&s=#urlencodedformat(startdate)#&e=#urlen : codedformat(enddate)#&d=#urlencodedformat(getinfo.division)#&g=#ur : lencodedformat(getinfo.globalid)#"><b>#total_cnt#</b></a></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
