CFGRID Question 3

[jwdcfdeveloper]

I need to be able to select a row of data from a grid, that is populated by a query, using some sort of selection process (i.e. radio buttons, check boxes, etc.) and update another table with this data. Does anyone have any ideas?

 

[KevinFSI]

Based on my experience with CFGRID, you really don't have the kind of flexability you're looking for. As I'm sure you know, you specify various parameters then populate the grid with your query results. Once that is done, CF generates an applet that is the grid. You don't have the power to manipulate it beyond what you tell it during the creation.

I screwed around with it for some time, only to turn around and use a table instead. Much greater flexability, and no need for your users to have JAVA enabled browsers. Kevin
slanek@ssd.fsi.com

 

[ram123]

It doesn't match exactly your requirement, but similar kind of solution.
When you click on any cfgrid row that goes to the next page and you can access all the information of the selected row.
If you want this code i will post it tomorrow morning

 

[tlhawkins]

Hi jwdcfdeveloper,

If you're really sure you need the <CFGRID> (I like it too) you can use the HREF attribute like this

<CFGRID name=&quot;Grabarow&quot; Query=&quot;MyData&quot; SelectMode=&quot;Row&quot; Sort=&quot;Yes&quot;>
<CFGRIDColumn Name=&quot;VarName1&quot; Href=&quot;UseThisData.cfm&quot;>
<CFGRIDColumn Name=&quot;VarName2&quot; >
<CFGRIDColumn Name=&quot;VarName3&quot; >
<CFGRIDColumn Name=&quot;VarName4&quot; >
</CFGRID>

The Link will send all data in the row in a Comma-seperated list of values from the row.

You can also manually populate the grid with
<CFGRIDCOLUMN Name=&quot;Column1&quot; Header=&quot;First Column&quot;>
<CFGRIDCOLUMN Name=&quot;Column2&quot; Header=&quot;Second Column&quot;>
<CFGRIDCOLUMN Name=&quot;Column3&quot; Header=&quot;Third Column&quot;>
<CFGRIDROW Data=&quot;Val1 , Val2, Val3&quot;>
<CFGRIDROW Data=&quot;Val1 , Val2, Val3&quot;>

I only mention this because you could manually populate the grid with data with a <CFOUTPUT query=&quot;MyData&quot;>
Then add a Column that has a link to send the Row of data to your next page.

Hope This Helps.
Otherwise KevinSFI is right about the tables.

 

[jwdcfdeveloper]

Thanks for the suggestions, I will probably to the table route, since I know a little more about them then grids, and I don't have a lot of time. Thanks again.