CFGrid question - Help!

[sysadmin]

Ok, I have spent days on this and have gotten nowhere. Can somebody help?

I have a CFGrid displaying information from a database. I would like a user
to be able to select a record and somehow pass the url to an edit screen so
they can access the full record. I see entries in the help file for using
Href and targets but I'm afraid this isn't clear. I already have the "edit"
screen which successfully accepts a url variable passed to it, I just need
that url variable set to what the user selects in the grid.

Can somebody help me out?

[sysadmin]

Ok, I have spent days on this and have gotten nowhere. Can somebody help?

I have a CFGrid displaying information from a database. I would like a user
to be able to select a record and somehow pass the url to an edit screen so
they can access the full record. I see entries in the help file for using
Href and targets but I'm afraid this isn't clear. I already have the "edit"
screen which successfully accepts a url variable passed to it, I just need
that url variable set to what the user selects in the grid.

Can somebody help me out?

[jmj]

The help file is correct you will want to use the a href tag. Choose the
column that you want the user to click (Name/Title/whatever)
Then you will wrap the a href around the variable in the column and send the
Id or whatever
<a href="Mypage.cfm?ID=#query.ID#>#query.NAME#</A>
You use the query that is populating the grid as the query that will send the
id in the url.
So now if my grid showed the following:
Name Address City State Zip Phone
All the names listed would be highlighted as a link.
Hope this helps. Good luck.