Databases
StackOverflow2013
Postsdbo
POCan I replace the cfgridkey with my own custom variable name? Or else build my own href?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan I replace the cfgridkey with my own custom variable name? Or else build my own href?
    primarykey
    data
    text
    <p>I have a simple cfgrid that's displaying my ids. I want the id to be a link to a new page, passing a url parameter of "myID" with the id value.</p> <p>I've tried this code: </p> <pre><code>&lt;cfgrid name="myGrid" query="myQuery" format="html"&gt; &lt;cfgridcolumn name="myID" href="mynewpage.cfm" /&gt; &lt;/cfgrid&gt; </code></pre> <p>But this takes me to the url "mynewpage.cfm?<strong>hrefkey</strong>=111". What I really want is "mynewpage.cfm?<strong>myID</strong>=111". Is there any way to specify what the name of the url parameter should be?</p> <p>I've also tried:</p> <pre><code>&lt;cfgrid name="myGrid" query="myQuery" format="html"&gt; &lt;cfgridcolumn name="myID" href="mynewpage.cfm?myID=#myID#" /&gt; &lt;/cfgrid&gt; </code></pre> <p>But then I get the error "<code>myID is not defined</code>". Is there any way to reference query field values from within a cfgridcolumn tag?</p> <p><strong>UPDATE:</strong></p> <p>Another thing I've tried - building the string in the sql query so that I return a column called <code>myURL</code> with a value of "mynewpage.cfm?myID=111", and then using that column for the href attribute:</p> <pre><code>&lt;cfgrid name="myGrid" query="myQuery" format="html"&gt; &lt;cfgridcolumn name="myID" href="#myURL#" /&gt; &lt;/cfgrid&gt; </code></pre> <p>According to the <a href="http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_g-h_04.html" rel="nofollow">coldfusion documentation</a> you should be able to do this:</p> <blockquote> <p>href - URL <em>or query column name</em> that contains a URL to hyperlink each grid column with. </p> </blockquote> <p>(italics mine)</p> <p>But I get the error "<code>myURL is not defined</code>". How do I set the href to a column rather than a literal url value?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USfroadie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan I replace the cfgridkey with my own custom variable name? Or else build my own href?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCan I replace the cfgridkey with my own custom variable name? Or else build my own href?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCan I replace the cfgridkey with my own custom variable name? Or else build my own href?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI did a brief search and only found threads [like this](http://forums.adobe.com/thread/510290) or [this one](http://forums.forta.com/messages.cfm?threadid=C72175F0-0974-85CE-B1052899FF1E9AAD) which seem to indicate it is not possible. (Maybe by tapping into the extjs stuff?)
      singulars
      1. POCan I replace the cfgridkey with my own custom variable name? Or else build my own href?
      1. USLeigh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload