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_lab el" 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= #dispSearc h.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
<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_lab
</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=
i.e. IF you click the cfgridcolumn name="username". ... i need to href the user to '/page_viewprofile.cfm?u=#
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.