1 Reply Latest reply on Sep 19, 2007 7:34 AM by aredovian

    How to loop and add multiple records from db in .pdf using cfdocument

    Lucky_Kitty Level 1
      I have a query that pulls a users information (Id, FirstName, LastName, Title,etc). I then use cfdocument to output a person's biography into a pdf. This is great, because we no longer have to manually create bios, as they are now all dynamically generated. The problem I have now is that we want to be able to select multiple users and create a .pdf with each of their bios included in the one pdf.

      How do I loop thru records from a sql database in a cfdocument that includes a header and footer in cfdocument items, and ensure that one persons bio doesn't continue on the page with anothers.

      Here's the code I have so far for the cfdocument: