Hi, if the name of the file in the database is the same as the name of the file in the asset manager, then you could a snippet of RQL in order to assign the matching file to the media element. First of all you'd have to list all assets and then loop through them and connect the asset with the matching media element. This could be written in the template directly but with increasing numbers of files the performance would decrease. Therefore I'd recommend to create a user-defined job that is executed before the publication starts. As I don't know the number of files and how often they change it's hard to find the best answer....
Best regards, Manuel P.S.: Maybe you post the question at www.SolutionExchange.info ....there a lot of other guys could possibly find another/better solution. On 9 Feb., 03:07, gk <gail.b...@tga.gov.au> wrote: > I'm trying to create a content class that writes table data by pulling > it out of an Access database. Getting the values out of the database > is working fine however for each row I also need to link to a pdf file > that is located in asset manager (different pdf for each row). Is this > possible? I certainly can't work out how to do it. My current content > class looks like: > > <table> > <thead> > <tr> > <th scope="col">Column 1</th> > <th scope="col">Column 2</th> > <th scope="col">Column 3</th> > <th scope="col">Column 4</th> > <th scope="col">Column 5</th> > <th scope="col">Column 6</th> > </tr> > </thead> > <tbody> > <!IoRangeData><tr> > <td scope="row"><a class="pdf" > href="[ioID]0DBBF1A3D1EC4DE0AB48A4366AA7FA1E/<%db_pdf_filename%>">< > %db_column1%> (pdf,<%db_pdf_filesize%>Mb)</a></td> > <td><%db_column2%></td> > <td><%db_column3%></td> > <td><%db_column4%></td> > <td><%db_column5%></td> > <td><%db_column6%></td> > </tr><!/IoRangeData> > </tbody> > </table> > </div> -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to reddot-cms-users@googlegroups.com. To unsubscribe from this group, send email to reddot-cms-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
