Hi Rupesh,

Thanks a lot for your reply. Here are the code:

<!--- track your initials through URL --->
<cfparam name="URL.myIni" default="">   

<!--- only pint out proctor labels for the exams which is not taken in CU
if cu = 0, the exam is not taking in cu. --->
<cfquery name="printProcessedReq" datasource="cepswebapps">
        SELECT * FROM examrequest
        WHERE readyToPrint = 1 AND proctorLabelPrinted != 1AND initials = 
'#URL.myIni#' AND printed !=1 AND cu = 0
</cfquery>

<cfif printProcessedReq.RecordCount is not 0>
<cfdocument format="pdf" unit="in" margintop="0.05" marginbottom="0" 
marginleft="0.05" marginright="0.05"   pagetype="custom" pagewidth="2.25" 
pageheight="2" fontembed="yes" orientation="portrait" scale="100">

<cfoutput query="printProcessedReq">

<!--- the following 'if block' will prevent creating an extra blank page at the 
end of the document --->
<cfif printProcessedReq.CurrentRow gt 1>
<cfdocumentitem type="pagebreak"/>
<!---h1>Forced paged break</h1--->
</cfif>

<font style=" font-size:50px">#procname# </font><br>
<font style=" font-size:50px">#procinstitution# </font><br>
<font style=" font-size:50px">#procaddress#<br></font>
  <cfif procaddress2 is not "">
<font style=" font-size:50px">#procaddress2#<br></font>
</cfif>
<font style=" font-size:50px">#proccity#, #procstate# 
#proczip#<br>#proccountry#</font>

</cfoutput></cfdocument>        

<cfelse>
<p>
<strong>Sorry! There are no processed requests for printing. Click Back button 
for the other options.</strong></p>
</cfif>         

Would you please let me know if I am experiencing the same problem you recently 
fixed?

Thanks.




> Hi,
> Could you please post the complete code that can replicate this? We 
> have fixed a similar bug recently and a cumulative hotfix will be 
> going out recently.
> Regards,
> Rupesh.
> Adobe ColdFusion Team 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293976
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to