asked on
The rendering of <cfdocument format="pdf"> takes FOREVER.
I have tried using a progressbar and <cfflush> but the document just doesn't render fast enough.
Any suggestions?
<!--- Code Begins --->
<cfquery name="qryClassDetail" datasource="#session.connS
SELECT tblParts.PartID, tblParts.Description, tblParts.Price, tblParts.Unitofmeasure, tblParts.resale, tblParts.NetPricing, tblClass.class AS Class,
tblClass.Description AS classDescription
FROM tblParts INNER JOIN
tblClass ON tblParts.class = tblClass.class
WHERE (tblParts.resale = 'y') AND (tblParts.Price <> '0') AND (tblParts.PartID NOT LIKE '%BLANK%') AND (tblParts.class NOT LIKE '%2') AND (tblParts.class <> 'DBME') AND (tblParts.class <> 'ELE') AND
(tblParts.class <> 'RMB') AND (tblParts.class <> 'SCC') AND (tblParts.class <> 'TP') AND (tblParts.class <> 'MISC') AND (tblParts.class <> 'M&C')
GROUP BY tblClass.class, tblParts.PartID, tblParts.Description, tblParts.Price, tblParts.Unitofmeasure, tblParts.resale, tblParts.NetPricing,
tblClass.Description
ORDER BY tblClass.class
</cfquery>
<body bgcolor="#FFFFFF" leftmargin="65">
<h3>Please Wait</h3><br>
The pages are loading...<br>
<img name="meter" width="200" height="16" src="../images/progressbar
<cfflush>
<cfloop from="0" to="100" step="25" index="i">
<cfdocument format="pdf">
<table cellpadding="1" cellspacing="0" border="0" width="620">
<cfoutput query="qryClassDetail" group="Class">
<tr><td colspan="4"> </td></t
<tr bgcolor="##4E8FD1">
<td colspan="4"><font color="##F2F2F2"><h3> 
</tr>
<tr bgcolor="##CCCCCC">
<td width="140"><strong> Image</strong></td>
<td width="100"><strong>PartID
<td width="328"><strong>Descri
<td align="center" width="52"><strong>Retail<
</tr>
<cfoutput>
<cfif qryClassDetail.resale NEQ "n">
<cfset PartID = trim(qryClassDetail.PartID
<cfset netPrice=qryClassDetail.ne
<tr>
<td align="left">
<img height="40" src="../images/parts/#trim
</td>
<td> #PartID#</font><
<td>
#qryClassDetail.Desc
</td>
<td align="right">
#NumberFormat(qryClassDeta
<cfif netPrice EQ "n">
<br />
<font style="text-align:right">(
</cfif>
</td>
</tr>
</cfif>
</cfoutput>
</cfoutput>
</table>
</cfdocument>
<cfoutput>
<script language="javascript">
document.images["meter"].s
</script>
</cfoutput>
<cfflush>
</cfloop>
I have tried using a progressbar and <cfflush> but the document just doesn't render fast enough.
Any suggestions?
<!--- Code Begins --->
<cfquery name="qryClassDetail" datasource="#session.connS
SELECT tblParts.PartID, tblParts.Description, tblParts.Price, tblParts.Unitofmeasure, tblParts.resale, tblParts.NetPricing, tblClass.class AS Class,
tblClass.Description AS classDescription
FROM tblParts INNER JOIN
tblClass ON tblParts.class = tblClass.class
WHERE (tblParts.resale = 'y') AND (tblParts.Price <> '0') AND (tblParts.PartID NOT LIKE '%BLANK%') AND (tblParts.class NOT LIKE '%2') AND (tblParts.class <> 'DBME') AND (tblParts.class <> 'ELE') AND
(tblParts.class <> 'RMB') AND (tblParts.class <> 'SCC') AND (tblParts.class <> 'TP') AND (tblParts.class <> 'MISC') AND (tblParts.class <> 'M&C')
GROUP BY tblClass.class, tblParts.PartID, tblParts.Description, tblParts.Price, tblParts.Unitofmeasure, tblParts.resale, tblParts.NetPricing,
tblClass.Description
ORDER BY tblClass.class
</cfquery>
<body bgcolor="#FFFFFF" leftmargin="65">
<h3>Please Wait</h3><br>
The pages are loading...<br>
<img name="meter" width="200" height="16" src="../images/progressbar
<cfflush>
<cfloop from="0" to="100" step="25" index="i">
<cfdocument format="pdf">
<table cellpadding="1" cellspacing="0" border="0" width="620">
<cfoutput query="qryClassDetail" group="Class">
<tr><td colspan="4"> </td></t
<tr bgcolor="##4E8FD1">
<td colspan="4"><font color="##F2F2F2"><h3> 
</tr>
<tr bgcolor="##CCCCCC">
<td width="140"><strong> Image</strong></td>
<td width="100"><strong>PartID
<td width="328"><strong>Descri
<td align="center" width="52"><strong>Retail<
</tr>
<cfoutput>
<cfif qryClassDetail.resale NEQ "n">
<cfset PartID = trim(qryClassDetail.PartID
<cfset netPrice=qryClassDetail.ne
<tr>
<td align="left">
<img height="40" src="../images/parts/#trim
</td>
<td> #PartID#</font><
<td>
#qryClassDetail.Desc
</td>
<td align="right">
#NumberFormat(qryClassDeta
<cfif netPrice EQ "n">
<br />
<font style="text-align:right">(
</cfif>
</td>
</tr>
</cfif>
</cfoutput>
</cfoutput>
</table>
</cfdocument>
<cfoutput>
<script language="javascript">
document.images["meter"].s
</script>
</cfoutput>
<cfflush>
</cfloop>
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.