5 Replies Latest reply on Oct 28, 2008 10:49 AM by jolmesp

    PDF Generation with database fields

    jolmesp
      Hi!

      Well I have some questions and I was wondering if someone would be kind enough to answer. Here it goes.

      Scenario:
      The company that I work for is a non-profit educational institution. They wish to do a tax receipts project in which a student can log on to our website and get a tax receipt for all the courses they've take with us in the calendar year.

      The data for the student resides in a SQL Server 2000 database table. The tax receipt has to be presented in a PDF format. We have a PDF template that we have to use. Essentially, the PDF template has to populated with values from the database.

      Technical Environment: CF7, SQL 2K, Win 2003 Server, IIS 6.
      Constraints: output has to be PDF format, can't upgrade to CF8

      Question 1:
      Can a PDF document be populated with values from a database in ColdFusion 7??

      Question 2:
      If so, o you know of a book/website in which this type of work is detailed (a how-to)?

      Question 3:
      If the answer is "no" to the above, is there a tool that can be used to accomplish this?

      Thank you in advance! :)

      Jolmes