help! How to view my work in pdf
I haven't had the chance to work with PDF with CF 8 and I'm not sure where to start.
I'm currently producing a report from a DB and I'm showing it in a table but I was just told to add a link where our user can click and get that same report in PDF. Users may want to share the report, keep the report, etc
I did some reading and a brief testing but still confuse. Should I use CFDOCUMENT tags with format attribute set to "pdf"? and what other attributes do I need for this task? When I ran mypdftest.cfm with the following codes, I got my pdf:
<cfdocument format="pdf">
Hello this is a test
</cfdocument>
but when I added a query on my second test and try to out put the result, I got my pdf but instead of showing the query result, I got strange characters
everywhere.
<cfdocument format="pdf">
<cfquery name="test" datasource="#application.dsn#">
Select * from some table where LastName = 'Allen'
</cfquery>
<table>
<tr>
<td>First Name</td>
<td>Last Name</td>
</tr>
<cfoutput query="test">
<tr>
<td>#FName#</td>
<td>#LName#</td>
</tr>
</cfoutput>
</table>
</cfdocument>
Can anyone help????
