Link to home
Start Free TrialLog in
Avatar of rcbuchanan
rcbuchanan

asked on

CFGRID (mx7) - href for each column?

Can u help. I'm having fun creating cfgrid flash forms using CFmx7 and i need to modify my form below ...

<cfquery name="dispSearch" datasource="fred">
select * from opinions op join users u on u.userid = op.userid join opinion_categories oc on oc.opinion_category_id = op.opinion_category_id where opinion_title like '%bush%'
</cfquery>

<table width="605" align="left" border="0">
<tr>
<td width="605" align="left">
<cfform name="OpGrid">
<cfgrid name="grid" format="flash" width="605" height="400" query="dispSearch" selectmode="single" font="Verdana, Arial, Helvetica, sans-serif" fontsize="9"  rowheight="15" colheaderbold="yes">
<cfgridcolumn name="opinion_title" header="opinion topic" width="305">
<cfgridcolumn name="username" header="member" width="120">
<cfgridcolumn name="opinion_category_label" header="category" width="120">
</cfgrid>
</cfform>
</td>
</tr>
</table>


i need to allow the user to click the three columns to be taken to specific pages - based upon the record specific content of that record.

i.e. IF you click the cfgridcolumn name="opinion_title". ... i need to href the user to '/page_viewopinion.cfm?op=#dispSearch.opinion_id#'

i.e. IF you click  the cfgridcolumn name="username". ... i need to href the user to '/page_viewprofile.cfm?u=#dispSearch.userid#'

etc!

I can see the cfgridcolumn tag allows for href="URL" but it does not seem to want to work!

any ideas?
Richard
ASKER CERTIFIED SOLUTION
Avatar of mmc98dl1
mmc98dl1
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial