Link to PDF using cfgridcolumn and href using hrefkey

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-05-11

Trying to call a PDF in a directory which is the same name in table.  The ECN variable does not have the .pdf extension included so I need to add it to be able to link it and view it.  So the ???? needs to be variable ECN plus".pdf" - hope this makes sense?

<cfgrid format="html"...>
      <cfgridcolumn name="ECN"  header="PDF" width="55" href="MainHist/????" target="_blank" display="yes" hrefkey="ECN" select="false"/>

So if I run this by clicking on ECN 005252 the url looks likes this:


Thanks for your help

Question by:Nigel-SA

Accepted Solution

nmarano earned 2000 total points
ID: 35763823
<cfset fileName = "#ECN#.pdf">

And point the link to the pdf folder.


Author Comment

ID: 35818718
nmarano - thanks - almost there. How do I cfset a variable that is within a query?

<cfquery name="xxxx" datasource="yyy">
                   SELECT  ECN, TARA_ID
                    FROM MRE_TARA_LIST

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question