Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
CFFLUSH and IE5 x - 6 0
Author: Jochem van Dieten
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128048
Tony Weeg wrote:
> oh yeah, I knew that, but Ive heard many on here, say the same thing...
Then it must be true :-)
> I havent found div/layers/spans to be as universal across the board
> as tables, and cross browser wise, arent tables just much more safe?
Layers are an abomination, but divs and spans are pretty universal
actually. As long as you don't have to support NS4 there really is
little need to go to tables (and NS4 will still display the contents
correctly, it will just be formatted ugly, but that is something NS4
users should be used to by now).
The real question is whether you want to sacrifice forward compatibility
for the sake of a little backward compatibility.
Jochem
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128026
oh yeah, I knew that, but Ive heard many on here, say the same thing...
I havent found div/layers/spans to be as universal across the board
as tables, and cross browser wise, arent tables just much more safe?
tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337
Although I could go on and on, my statement was a joke. See the smiley?
----- Excess quoted text cut - see Original Post for more -----
Author: ksuh
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128025
Although I could go on and on, my statement was a joke. See the smiley?
----- Excess quoted text cut - see Original Post for more -----
Author: Dan G. Switzer, II
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128024
You can also use multiple <tbody> tags--which should help force the
rendering of the page.
You're also better off using <div>s to set up your web site "shell" instead
of tables--this will speed up rendering as well.
-Dan
----- Excess quoted text cut - see Original Post for more -----
Author: Tony Weeg
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128022
whats wrong with tables for layout?
tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337
What are you doing using tables for layout? :P
----- Excess quoted text cut - see Original Post for more -----
Author: ksuh
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128021
What are you doing using tables for layout? :P
----- Excess quoted text cut - see Original Post for more -----
Author: Tyler Silcox
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128020
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
Thanks,
This looks really interesting and I am going to give it a try today.
Mario
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.
----- Excess quoted text cut - see Original Post for more -----
Author: Ciliotta, Mario
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#128007
Thanks,
This looks really interesting and I am going to give it a try today.
Mario
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.
----- Excess quoted text cut - see Original Post for more -----
Author: Joshua Miller
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127773
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
webmaster@garrisonenterprisesdigital.com
(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 postmaster@garrisonenterprisesdigital.com
************************************************************************
*************
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"> #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.
Author: Joshua Miller
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127774
INTERESTING! Thanks for that tidbit!
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
webmaster@garrisonenterprisesdigital.com
(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 postmaster@garrisonenterprisesdigital.com
************************************************************************
*************
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.
----- Excess quoted text cut - see Original Post for more -----
Author: S. Isaac Dealey
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127771
----- Excess quoted text cut - see Original Post for more -----
So of course, google searches for Anna Karinnina are more likely to produce any
of those pages. heh. :)
Incidentally, I believe IE treats whitespace normally as part of that 1k, so I
think you could just as well use #repeatString(" ",1000)# or at the very least
#repeatString(" |",500)# although it'd look strange when you view the source...
but then... I'd be confused if I saw several pages of Anna Karinnina in the
source. :)
s. isaac dealey 972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
team macromedia volunteer http://www.macromedia.com/go/team
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
Author: ksuh
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127751
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.
----- Excess quoted text cut - see Original Post for more -----
Author: Ciliotta, Mario
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127752
Thanks Ben,
I'll give that I try and see if it works.
Mario
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-----
:
: 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.
:
:
:
Author: Ben Doom
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127750
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-----
:
: 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.
:
:
:
Author: Ciliotta, Mario
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:25375#127747
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.
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
