<div>
nmarano - thanks - almost there. How do I cfset a variable that is within a query?<br />
<br />
&lt;cfquery name=&quot;xxxx&quot; datasource=&quot;yyy&quot;&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT &nbsp;ECN, TARA_ID<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM MRE_TARA_LIST<br />
&lt;/cfquery&gt;
</div>


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
</cfquery>

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
Trying to call a PDF in a directory which is the same name in table. &nbsp;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. &nbsp;So the ???? needs to be variable ECN plus&quot;.pdf&quot; - hope this makes sense?<br />
<br />
&lt;cfgrid format=&quot;html&quot;...&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfgridcolumn name=&quot;ECN&quot; &nbsp;header=&quot;PDF&quot; width=&quot;55&quot; href=&quot;MainHist/????&quot; target=&quot;_blank&quot; display=&quot;yes&quot; hrefkey=&quot;ECN&quot; select=&quot;false&quot;/&gt;<br />
&lt;/cfgrid&gt;<br />
<br />
So if I run this by clicking on ECN 005252 the url looks likes this:<br />
<br />
&quot;MainHist/?????&amp;CFGRIDKEY=<wbr />005252&quot;<br />
<br />
Thanks for your help<br />
<br />

</div>
</div>


Experts,

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"/>
</cfgrid>

So if I run this by clicking on ECN 005252 the url looks likes this:

"MainHist/?????&CFGRIDKEY=005252"

Thanks for your help



Link to PDF using cfgridcolumn and href using hrefkey

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Adobe Dreamweaver is a web development tool featuring both WYSIWYG and code editors that allow the user to quickly and easily build websites in a wide variety of languages, including ASP, ASP.NET, ColdFusion and PHP. It also offers support for CSS and JavaScript.