Reply to topic
CFGRID
Ennio


Joined: 17 Nov 2006
Posts: 97
Location: Scotch Plains, NJ
Post Posted: Fri Jun 06, 2008 3:11 pm Reply with quote
I'm trying to add a link to a CFGRIDCOLUMN and I need some help, I setup the link but I need to send the user id from the DB query to the link field how can I do that.

here is my code.

Code:

<cfform method="post">
    <cfgrid name="gridUsers" query="qryGetUsers" format="html" stripeRows="true">
        <cfgridcolumn name="id" display="yes" href="payment.cfm?id=">  ---> NEED TO ADD ID
        <cfgridcolumn name="fname" display="yes" header="First Name">
        <cfgridcolumn name="lname" display="yes" header="Last Name">
        <cfgridcolumn name="enddate" display="yes" header="Expiration Date">
    </cfgrid>
</cfform>
Ennio


Joined: 17 Nov 2006
Posts: 97
Location: Scotch Plains, NJ
Post Posted: Mon Jun 09, 2008 5:30 pm Reply with quote
I found the way.
Here is how I did. Where the number 1 is the location in the grid.
Code:

#ListGetAt(URL.CFGRIDKEY,1)#
palyne


Joined: 23 Oct 2006
Posts: 13
Post Posted: Sun Aug 03, 2008 10:21 am Reply with quote
I would like to have found something that easy LOL. I eventually ended up doing a string concatenation in my SQL query (in the CFC I was binding to the cfgrid) that literally inserted a full link, the value of the record ID, and an img ref (same image for every record), and then output that as a column value.
CFGRID
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
 		All times are GMT  
Page 1 of 1  
  
  
 Reply to topic