March 01, 2006

Curious Coldfusion George. I need to make my database of PDF's available online.

I am new to this Coldfusion thing. I have a list of titles. When you click on a title, it takes you to a page of citations associated with that title. At the top of this page, I want a link to the PDF of this title but I do not know how. I have the PDF's embedded in an Access file and I am working with Coldfusion to make dynamic pages. I have been trying to find examples online but I don't seem to know the pagic words as I am finding bupkiss.

posted by Hotcakes 18 years ago
  • the only advice i can give is don't trust fleischmann and pons.
  • Your Access database has to be set up as a datasource. Assuming your Access database has the titles and filenames of the PDFs, here's how to do the query: SELECT Title,Filename FROM ACCESSTABLE Here's how to display the filenames in a list: [ul] [li][a href="#Filename#"]#Title#[/a][/li] [/ul] Here's how to display the filenames in a table: [table] [tr][td][a href="#Filename#"]#Title#[/a][/td][/tr] [/table] Change the Access filename and field names to match your database, and change [] to <>.