cfgrid link to record

[oaklandar]

I am trying to show CFGRID and have the ability to link to a record:

<cfform action="theGridPage.cfm" enablecab="Yes" name="myForm">
	<cfgrid name="mygrid"  colheaderbold="Yes" query="QueryOne" sort="Yes" griddataalign="left" gridlines="yes" rowheaders="yes" colheaders="Yes" selectmode="edit" picturebar="Yes"> 
	                                                
	<cfgridcolumn name="ID" header="ID" href="test.cfm?ID=ID" dataalign="LEFT" select="No" display="Yes" type="STRING_NOCASE">

test.cfm page

select * from tableOne
where ID = #url.id#

Please advise because it keeps showing the first record only.

 

[MorganGreylock]

Should this:

<cfgridcolumn name="ID" header="ID" href="test.cfm?ID=ID" dataalign="LEFT" select="No" display="Yes" type="STRING_NOCASE">

Be this instead:

<cfgridcolumn name="ID" header="ID" href="test.cfm?ID=#ID#" dataalign="LEFT" select="No" display="Yes" type="STRING_NOCASE">

I'm not too familiar with the CFGRID tag, so I don't really know what else might be causing the problem.
Hope that helps,
MG

 

[oaklandar]

I already tried that and it didnt work. Any other advise?