This is to pull the data from stored preocedure.Part 1
<!--- Store Procedure to get the PDF from the specified Disclosure ID --->
<cfstoredproc procedure="csp_ONF_GetDisclosureData" datasource="Platform" >
<cfprocparam cfsqltype="CF_SQL_INTEGER" value="#application.banknumber#"
type="in">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#session.get_DisclosureID#"
type="in">
<cfprocresult name="Disclosure_Data" >
</cfstoredproc>
<!--- <cfdump var="#Disclosure_Data#"> --->
<!--- <cffile action="WRITE" file="C:\temp.pdf"
output="#ToString(Disclosure_Data.DocumentData)#"> --->
<cffile action="WRITE" file="C:\temp.pdf"
output="#toString(Disclosure_Data.DocumentData)#"/>
<!--- <cffile action="readbinary" file="C:\temp.pdf" variable="pdf_read"/>
<cffile action="WRITE" file="C:\temp.pdf" output="#get_PDF#"/>
--->
<cfset session.data_pdf=#ToString(Disclosure_Data.DocumentData)#>
<cfcontent file = "C:\temp.pdf" deleteFile = "no">
<!--- <cfheader name="temp_PDF" value="inline; filename=temp1.pdf"> --->
</body>
</html>
This file displays the data pulled from the Database using stored
Procedues.Part 2
<cfform action="confirmation.cfm">
<cfoutput query="Disclosure_results" group="Name">
<b>#Disclosure_results.Name# </b><br> <br>
<cfinput type="checkbox" name="cbx_text" value="value_text" required="yes"
message="Please accept Disclosure">
#Disclosure_results.displaytext#
<br><br>
<cfif #Disclosure_results.DocumentAvailable# eq '1'>
<cfset session.get_DisclosureID=#Disclosure_results.DisclosureID#>
<cfinput type="checkbox" name="cbx_pdf" value="value_pdfhyper" required="yes"
message="Please accept Disclosure">
<a href="getPDF.cfm">Please Click </a><br><br>
</cfif>
Now my problem is to merge the Part1 PDF generated in the browser and Part2
(text pulled out from databaseand also have sme form data and I saved in some
file which is also to be merged in to single PDF file I am unable to merge
using cfpdf. But I cannot even use cfpdf as it can store the file in some
location and not opens in browser.
Please help me out in merging the contents of the formData, PDF generated in
browser (Part1) and the data in the webpage pulled from Database (Part 2.) and
saving it in some temp file so that I again save that PDF file in the Database
using stored Procedure and also display in the browser.
This is my code to save as well as display in the browser.
<cfsavecontent variable="data">
<cfoutput>
<strong> Confirmation </strong>
<table width="500" border="0" align="center">
<tr> </tr>
<tr>
<td>FirstName</td>
<td>#session.F_name#</td>
</tr>
<tr>
<td>M.Initial</td>
<td>#session.M_initial#</td>
</tr>
<tr>
<td>LastName</td>
<td>#session.L_name#</td>
</tr>
<tr>
<td>Address</td>
<td>#session.Add1# #session.Add2#</td>
<tr>
<td></td>
<td>#session.City_name# #session.State_Name#
#session.Zip_Name# </td>
<tr> </tr>
<tr>
<td>TIN</td>
<td>#session.TIN_number#</td>
</tr>
<tr>
<td>DOB</td>
<td>#session.DOB#</td>
</tr>
<tr>
<td>E-mail</td>
<td>#session.email#</td>
</tr>
<tr>
<td>Phone</td>
<td>#session.Phone#</td>
</tr>
<br>
<br>
</table>
<p>
</cfoutput>
</cfsavecontent>
<!--- to generate file in any folder--->
<cfdocument format="pdf" overwrite="yes" name="info_pdf" filename="C:\my.pdf">
<!--- <cfdocumentitem type="header"> <font>Header</font> </cfdocumentitem>
<cfdocumentitem type="footer"> <font>Footer</font> </cfdocumentitem> --->
<cfoutput>#data#</cfoutput>
<cfdocumentitem type="pagebreak"/>
<table align="center">
<tr>
<td>
<div align="center">
Disclosures:
<cfoutput query="session.Disclosure_results"
group="Name">
</div>
<br>
<b>#session.Disclosure_results.name#</b>
<br>
#session.Disclosure_results.displaytext# <br>
</td>
</tr>
</table>
</cfoutput>
</cfdocument>
<!--- showing the pdf in window--->
<cfdocument format="pdf" overwrite="yes">
<cfoutput>#data#</cfoutput>
<cfdocumentitem type="pagebreak"/>
<table align="center">
<tr>
<td>
<div align="center">
Disclosures:
<cfoutput query="session.Disclosure_results"
group="Name">
</div>
<br>
<p><font size=2><b>#session.Disclosure_results.name#:</b></font>
</p>
<p> #session.Disclosure_results.displaytext# </p><br>
</td>
</tr>
</table>
</cfoutput>
</cfdocument>
Please can anyone help me out with this..?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
