I've noticed this too, CFFLUSH won't partially output a table in any
browser I've tried, which is pretty irritating since (unfortunately)
most of my data-output is in table cells.

Admittedly I haven't tried them all, but IE5.x, IE6.x, Mozilla, Opera
and Safari don't seem to oblige.

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-0801 ext. 254
 
************************************************************************
*************
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
************************************************************************
*************


-----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=#urlencodedf
ormat(enddate)#&d=#urlencodedformat(getinfo.division)#&g=#urlencodedform
at(getinfo.globalid)#"><b>#total_cnt#</b></a></td>  
                        <td width="20%" class="font2"
align="left">&nbsp;#employee#</td>
                        <td width="20%" class="font2"
align="left">&nbsp;#division#</td>
                        <td width="20%" class="font2"
align="left">&nbsp;#registered#</td>
                        <td width="20%" class="font2"
align="Left">&nbsp;#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
                                

Reply via email to