CFGRID (mx7) - href for each column?

Posted on 2005-04-20
Last Modified: 2013-12-24
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%'

<table width="605" align="left" border="0">
<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">

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#'


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

any ideas?
Question by:rcbuchanan
    1 Comment
    LVL 12

    Accepted Solution


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
    Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now