Skip to main content
B
bebright09
Known Participant
June 19, 2009
Answered

..more

  • June 19, 2009
  • 2 replies
  • 748 views

Hi guys thanks for your spontanious responses

                                            I am pulling data from table in which one column has huge information, I am displaying first 50 char of that column for all record in that table  with a clik here for more,  when a user want to see more information of particular message it always generating same result

how to identify for which message user clicked the option and display message as per that request..

    This topic has been closed for replies.
    Correct answer ilssac

    Usually by passing sometype of ID key value for which record was selected that can be used to retreive and/or display the full record.

    I.E.A very baisc version:

    <a href="displayData.cfm?id=#myData.key#>#left(myDate.description,50)#</a>

    2 replies

    ilssac
    ilssacCorrect answer
    Inspiring
    June 19, 2009

    Usually by passing sometype of ID key value for which record was selected that can be used to retreive and/or display the full record.

    I.E.A very baisc version:

    <a href="displayData.cfm?id=#myData.key#>#left(myDate.description,50)#</a>

    D
    Dan_Bracuk
    Inspiring
    June 19, 2009

    I'd do something like this.

    select id, description

    from etc

    <cfoutput query = "your query">

    <a href="something.cfm?description="#urlencodedformat(description)#">#left(description, 50)#</a>

    Then on the action page, output url.description

    ilssac
    ilssac
    Inspiring
    June 19, 2009

    Dan Bracuk wrote:

    <cfoutput query = "your query">

    <a href="something.cfm?description="#urlencodedformat(description)#">#left(descrip tion, 50)#</a>

    That seems a bit excessive to my, you would urlencode and potentially very long string and try to pass it as a get parameter?  There are limits to how much data can be passed through the url query string.  Admittedly that is about 2k which can be a fair amount of text, but I probably would pass a smaller identifery myself.

    B
    bebright09Author
    Known Participant
    June 19, 2009

    Passing Id works fine passing entire description did not worked

    THanks guys , espically Ian Skinner  you had helped me couple of other time too you rock...

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices