Did you see my response?
On Tue, Jan 6, 2009 at 9:48 AM, Priya Koya <[email protected]> wrote: > Can any one help me put with this????? > > > > >> 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:317478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
