Skip to main content
aetb846k
Participant
Apr 2, 2016 1:36 AM UTC
Answered

display active link.

if someone types a url into a form field and it goes into a mysql database. how do i get it to display as an active link on the display page.

    This topic is closed to new replies. Start a new post to keep the conversation going.
    BKBK
    BKBKCorrect answer
    Community Expert
    Apr 3, 2016 8:33 AM UTC

    Thanks i changed all those settings without a problem...So basically i want to take a url (e.g. http://www.google.com)  thats stored in my data base and display as an active link to the url http://www.google.com


    aetb846k wrote:

    Thanks i changed all those settings without a problem...So basically i want to take a url (e.g. http://www.google.com)  thats stored in my data base and display as an active link to the url http://www.google.com

    I answered that earlier:

    <td><a href="#Recordset1.name#" title="Google homepage">Google</a></td>

    This assumes that the value of Recordset1.name is  http://www.google.com

    View reply

    8 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Apr 2, 2016 12:25 PM UTC

    <!--- Do select query to retrieve URL from database --->

    <cfquery name="orgDetails" datasource="myDSN">

    select orgID, webURL

    from someTBL

    where orgID=1234

    </cfquery>

    <!--- Display link on page --->

    <a href="#orgDetails.webURL#" title="Organisation X homepage">Organisation X</a>

    Translate
    aetb846kAuthor
    Participant
    Apr 2, 2016 5:59 PM UTC

    <p>thanks for your time!  I tried to manipulate that code into what i have and it's throwing internal server error.  I'd like the name field to be the active link from the url they type in.    heres what i have for my output code.

    <cfoutput query="Recordset1">

        <tr>

          <td>#Recordset1.breed# </td>

          <td>#Recordset1.name#</td>

          <td>#Recordset1.bred# </td>

         <td>#Recordset1.due# </td>

        </tr></p>

    Translate
    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Apr 2, 2016 6:43 PM UTC

    Since you want a link, I expected something like

    <td><a href="#Recordset1.name#" title="Some title">Some name</a></td>

    In any case, the internal server error suggests something else is playing up. Could you show us your query.

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