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=#urlencodedformat(enddate)#&d=#urlencodedformat(getinfo.division)#&g=#urlencodedformat(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
