Skip to main content
A
Anonymous
August 3, 2009
Question

Links question

  • August 3, 2009
  • 2 replies
  • 860 views

So I working on what should be a fairly simple problem but it's one of those days where I cant see the forest from the trees. Any help would be appreicated.

I'm trying to create a link from a list of courses using a dynamically created value from the database.

                     <table><cfoutput query="jqpm">
                            <tr>
                                <td><img src="../../images/bullett.jpg" alt="bullet" /></td>
                                <td class="subtexttitle"><a href="#courseDeeplink#">#courseName#</a></td>
                            </tr></cfoutput>
                        </table>  

The courseName values load fine but when I click the link to go to the courseDeeplink value, it does nothing.  The values for the links in the db look like this:

                    https://cdsds.onsaba.net/Saba/Web/cdsds/goto/OfferingDetails?offeringId=dowbt0000054303479341

So when I roll over the #courseName#  list the following value appears below in the status bar of the browser:

                    http://mywebsite.com/index.cfm#https://cdsds.onsaba.net/Saba/Web/cdsds/goto/OfferingDetails?offeringId=dowbt0000054303479341#

Couple other things I should mention.  The values were uploaded from an Access DB (data type hyperlink) to SQL Server DB (data type nvarchar).  Not sure if this has any impact.  Just need another set of eyes.  Any insights would be appreciated.

Thanks,

Dee

    This topic has been closed for replies.

    2 replies

    A
    Anonymous
    August 5, 2009

    You might have a leading carriage return or line feed or tab with the data that is stored in the DB, and some browser may not like the extra space in the href tag.

    The CF trim() function may handle this.  I've exprienced issues where it does not, and have used a reReplace() with a regular expression \n\t\r to replace with "".

    off the top of my head

    #reReplace(courseDeeplink, "[]\n\t\r", "", "ALL")#  - that is line feeds, tabs and carriage returns.

    if there are spaces in courseDeeplink, do this to the variable first

    replace(courseDeeplink, " ", "%20", "ALL")

    This will give the proper encoding for the url in case there are spaces in the url (which is a bad practice, but might be the case).

    Sorry if my parameters are not in exact orderr, shooting from the hip.

    Byron Mann

    mannb@hostmysite.com

    byronosity@gmail.com

    Software Architect

    hosting.com | hostmysite.com

    http://www.hostmysite.com/?utm_source=bb

    A
    Anonymous
    August 7, 2009

    OfferingDetails?offeringId=dowbt0000054303479341


    Is your link missing a dot cfm reference ie should it be offeringdetails.cfm?offeringId=

    On the other hand, it could be that offeringdetails is a directory and you have mapped your default file correctly in that directory. In which case you can ignore my reply!

    D
    Daverms
    Inspiring
    August 3, 2009

    Dee,

    Either you need to change your field from "hyperlink" datatype to either "text" (or) "memo".

    (Or) if you can't,

    You can try this UDF,

    http://www.cflib.org/udf/AccessLinkClean

    HTH

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