I have set up a cold fusion page- I want the queries of that page to
populate my pdf. So the steps I take are:
1. set up pdftoolkit
2 set openinputFile.
3. set up queries
4. Output queries
5. In the cfoutput query statement add SetFormFieldData
6. Tlkt.CopyForm/Tlkt.ClearQueries
7. Go open new pdf form
Questions/Clarifications:
-I don't need a set openoutputfile since I'm using queries from the same
page. Is that correct?
- Do I need any special commands that say to use the queries. I thought that
the the CopyForm command is what I should use, but I want to make sure.
- Do I output the SetFormFieldData inside or outside the cfoutput statement?
- What is the correct way to use the SetFormFieldData in cf? I have used
<CFSET Name= Tlkt.SetFormFieldData(NAME,"#NAME#", 1)> and <CFSET Name=
Tlkt.SetFormFieldData(NAME,#NAME#, 1)> (no quotation marks around the
variable #NAME#)
I have not gotten my pdf to work correctly. I know my queries are fine- I
can output them to just a regular page- I just can't get it to populate the
pdf. I am adding my code, maybe you can spot something that I missed.
I appreciate any help. I apologize- my head has been extremely thick when
it comes to this activepdf stuff- I don't mean to flood the list, but.....
j
<!---Set up pdftoolkit/openinputfile---->
<CFOBJECT ACTION="Create" TYPE="COM" CLASS=APToolkit.Object NAME="Tlkt">
<CFSET R = Tlkt.OpenInputFile("RCard4_5.PDF")>
<CFSET DSN="http://Server/GradeCards.mdb";>
<!---Set up query--->
<CFQUERY NAME="StudentPrint" DATASOURCE="#Request.maindsn#">
SELECT FIRSTNAME, LASTNAME, PERMNUM
FROM ASTU_AllSchools
WHERE PERMNUM='#PERMNUM#'
ORDER By LASTNAME, FIRSTNAME
</CFQUERY>
<!---Output variables through cfoutput/ set up SetFormFieldData--->
<CFOUTPUT QUERY= "StudentPrint">
<CFSET NAME = "#StudentPrint.FIRSTNAME# #StudentPrint.LASTNAME#">
<CFSET Name= Tlkt.SetFormFieldData(NAME,"#NAME#", 1)>
</CFOUTPUT>
<!---Copy to pdf then clear query--->
<CFSET R=Tlkt.CopyForm(0,0)>
<CFSET R=Tlkt.ClearQueries()>
<CFSET Tlkt="">
<!---Open new pdf file with data---->
<CFLOCATION URL="http://172.16.7.42/ACFuseBox/FuseBox/Grades/RCard4_5.PDF";>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
