Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink in data?

    Hello,

    We have a site which pulls data from an Oracle Database into a web interface.
    We complained to our web designer that the URLs have no links.

    He says it's because it comes from a database.

    Please advise us on this b'cos most of the world's portals and big sites keep their content in databases, including ORACLE databases.

    And yet when you look at any CNN, Microsoft or Google News page, the link IS a hyperlink.

    Please advise us so we can help the designer realise he's wrong!

    Thanks,

    BD.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink in data?

    It's really hard to advise in this situation without knowing more about the data transfer/import process.

    Generally, when you want live hyperlinks from a URL stored in a database you'll want to use the following formatting:

    [URL_GOES_HERE]

    You may also want to add the target="_blank" attribute to make the page launch in its own external window.

    What is probably happening now is that the URL is being rendered by itself with no formatting and therefore no live hyperlink.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Hyperlink in data?

    So, you're saying, the page served up to the browser will list http://www.google.com/ but it is plain text and not a link?

    I think there are two options: (1) insert the necessary HTML tags or mock markup into your source data, and render them when serving up the page; or (2) add code to the server-side script that generates the pages to recognize and encode URLs as links. For #1, if the tags are already in there but the script is making them "safe" (disabling them), that probably is not such a big project. The source code of the page served up to the browser might reveal that. For #2, the least cost scenario is when URLs are stored in their own field in the database; the highest cost scenario is when the script has to scrutinize a big blob of free text, find URLs, and create the appropriate tags on the fly. Both could be a big project that likely will not get done for free.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •