printing attachments

Classic Servoy
1

I have a table called Customers. One of the fields in the Customers table is called Attachments (media field that stores PDF files). Since there may be many attachments for each Customer, I created an Attachments table and link the two tables using a customer_id field.

I would like to print out all the attachments related to a particular Customer in one combined PDF file. I’ve used plugins.pdf_output.combinePDFDocuments() in a previous method to accomplish something similar, but in this case I’m not sure how that would work across multiple records of another table.

thanks!!
Wes

Servoy 5.2.9
Smart Client
Windows

2

HI Wes,

just loop over the foundset, and combine them one by one…

pdf_blob_column = combinePDFDocuments(new Array(pdf_blob_column, other_pdf));

or create an array in the loop first, and than do one combine:

pdf_blob_column = combinePDFDocuments(new Array(pdf_blob1, pdf_blob2, pdf_blob3));