Hi Bob, First question:---------- Yes it is possible to populate the fields from a query.
Second question:---------- CFMX7 introduced the ability to create PDF documents using the <cfdocument> tag. This would allow for the inclusion of queried data and static data to be compiled into a PDF document. CF8 introduced the ability to populate fields on existing PDF documents using the <cfpdfform> and <cfpdfformparam> tags. So if all you want to do is query a database and output the results in a PDF document, then CFMX7 should be able to handle the situation. However, if your desire is to populate an existing pdf form, with the data from the database query, then you will need to use CF8. Note: It has been my experience that any content formatting inside a <cfdocument> tag needs be handled with inline CSS, as referencing to an external CSS does not seem to work. -- Excerpt from LiveDocs -- Manipulates existing forms created in Adobe® Acrobat® and Adobe® LiveCycle® Designer. The following list describes some of the tasks you can perform with the cfpdfform tag: â¢Embed an interactive form created in Acrobat LiveCycle in a PDF document. You use the cfpdfform tag to embed the PDF form in a cfdocument tag.. â¢Render an existing form created in Acrobat or LiveCycle. This includes prefilling fields from a database or an XML data file and processing form data from an HTTP post or PDF submission. â¢Extract or prefill values in stored PDF forms and save the output to a file or use it to update a data source. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4943 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
