What is the trick

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dvan
    #1

    What is the trick

    I have a field in my access DB, that is a hyperlink to an IP address.

    When I display that field on my site using ASP, the link doesn't come
    across.

    This is displayed
    162.136.133.36#http://162.136.133.36#

    The code to display the field is below
    response.write "<TD WIDTH=200>" & vbcrlf
    response.write( rs("IP_Address" ))
    response.write "</TD>" & vbcrlf

    Is there a workaround? I have also tried to make the field a text field
    with HTTP:// in front of the rs("IP_Address" ) and that doesn't work either.

    Thanks in advance.

    Doug


    Tags: None
    • Aaron [SQL Server MVP]
      #2
      Re: What is the trick

      Don't use the hyperlink datatype! Just store 'http://162.136.133.36' in a
      text(255) column. Your ASP is going to have to build a link anyway:

      ip = rs("IP_Address" )
      response.write( "<a href=" & ip & ">" & ip & "</a>")

      --
      Expired DNS Hosting Services | DNS Made Easy
      http://www.aspfaq.com/
      Please contact this domain's administrator as their DNS Made Easy services have expired.

      (Reverse address to reply.)




      "Dvan" <dthmtlgod@yaho o.com> wrote in message
      news:#K2GXySiEH A.2544@TK2MSFTN GP10.phx.gbl...[color=blue]
      > I have a field in my access DB, that is a hyperlink to an IP address.
      >
      > When I display that field on my site using ASP, the link doesn't come
      > across.
      >
      > This is displayed
      > 162.136.133.36#http://162.136.133.36#
      >
      > The code to display the field is below
      > response.write "<TD WIDTH=200>" & vbcrlf
      > response.write( rs("IP_Address" ))
      > response.write "</TD>" & vbcrlf
      >
      > Is there a workaround? I have also tried to make the field a text field
      > with HTTP:// in front of the rs("IP_Address" ) and that doesn't work[/color]
      either.[color=blue]
      >
      > Thanks in advance.
      >
      > Doug
      >
      >[/color]


        Comment

        • Dvan
          #3
          Re: What is the trick

          Aaron,

          One last question, that works fine, when I click on the link, it is putting
          my web server address in front of the IP address and the link won't work.

          Doug

          "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
          news:eLqVvKTiEH A.1644@tk2msftn gp13.phx.gbl...[color=blue]
          > Don't use the hyperlink datatype! Just store 'http://162.136.133.36' in a
          > text(255) column. Your ASP is going to have to build a link anyway:
          >
          > ip = rs("IP_Address" )
          > response.write( "<a href=" & ip & ">" & ip & "</a>")
          >
          > --
          > http://www.aspfaq.com/
          > (Reverse address to reply.)
          >
          >
          >
          >
          > "Dvan" <dthmtlgod@yaho o.com> wrote in message
          > news:#K2GXySiEH A.2544@TK2MSFTN GP10.phx.gbl...[color=green]
          > > I have a field in my access DB, that is a hyperlink to an IP address.
          > >
          > > When I display that field on my site using ASP, the link doesn't come
          > > across.
          > >
          > > This is displayed
          > > 162.136.133.36#http://162.136.133.36#
          > >
          > > The code to display the field is below
          > > response.write "<TD WIDTH=200>" & vbcrlf
          > > response.write( rs("IP_Address" ))
          > > response.write "</TD>" & vbcrlf
          > >
          > > Is there a workaround? I have also tried to make the field a text field
          > > with HTTP:// in front of the rs("IP_Address" ) and that doesn't work[/color]
          > either.[color=green]
          > >
          > > Thanks in advance.
          > >
          > > Doug
          > >
          > >[/color]
          >
          >[/color]


            Comment

            • Aaron [SQL Server MVP]
              #4
              Re: What is the trick

              Are you putting http:// in yourself? Or are you storing it? From your
              initial message, it looked like you were storing "http://x.x.x.x/" not
              "x.x.x.x" ... if the latter, well, you need to tell the browser that you
              don't mean a folder on your machine called "x.x.x.x" so

              response.write( "<a href=http://" & ip & ">" & ip & "</a>")

              --
              Expired DNS Hosting Services | DNS Made Easy
              http://www.aspfaq.com/
              Please contact this domain's administrator as their DNS Made Easy services have expired.

              (Reverse address to reply.)




              "Dvan" <dthmtlgod@yaho o.com> wrote in message
              news:uGx7tSTiEH A.1652@TK2MSFTN GP09.phx.gbl...[color=blue]
              > Aaron,
              >
              > One last question, that works fine, when I click on the link, it is[/color]
              putting[color=blue]
              > my web server address in front of the IP address and the link won't work.
              >
              > Doug
              >
              > "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
              > news:eLqVvKTiEH A.1644@tk2msftn gp13.phx.gbl...[color=green]
              > > Don't use the hyperlink datatype! Just store 'http://162.136.133.36' in[/color][/color]
              a[color=blue][color=green]
              > > text(255) column. Your ASP is going to have to build a link anyway:
              > >
              > > ip = rs("IP_Address" )
              > > response.write( "<a href=" & ip & ">" & ip & "</a>")
              > >
              > > --
              > > http://www.aspfaq.com/
              > > (Reverse address to reply.)
              > >
              > >
              > >
              > >
              > > "Dvan" <dthmtlgod@yaho o.com> wrote in message
              > > news:#K2GXySiEH A.2544@TK2MSFTN GP10.phx.gbl...[color=darkred]
              > > > I have a field in my access DB, that is a hyperlink to an IP address.
              > > >
              > > > When I display that field on my site using ASP, the link doesn't come
              > > > across.
              > > >
              > > > This is displayed
              > > > 162.136.133.36#http://162.136.133.36#
              > > >
              > > > The code to display the field is below
              > > > response.write "<TD WIDTH=200>" & vbcrlf
              > > > response.write( rs("IP_Address" ))
              > > > response.write "</TD>" & vbcrlf
              > > >
              > > > Is there a workaround? I have also tried to make the field a text[/color][/color][/color]
              field[color=blue][color=green][color=darkred]
              > > > with HTTP:// in front of the rs("IP_Address" ) and that doesn't work[/color]
              > > either.[color=darkred]
              > > >
              > > > Thanks in advance.
              > > >
              > > > Doug
              > > >
              > > >[/color]
              > >
              > >[/color]
              >
              >[/color]


                Comment

                • James Baker
                  #5
                  Re: What is the trick

                  Did you include the http in the href or is it just href=162.136.13 3.36? If
                  you include the http, it shouldn't be a problem.


                  "Dvan" <dthmtlgod@yaho o.com> wrote in message
                  news:uGx7tSTiEH A.1652@TK2MSFTN GP09.phx.gbl...[color=blue]
                  > Aaron,
                  >
                  > One last question, that works fine, when I click on the link, it is[/color]
                  putting[color=blue]
                  > my web server address in front of the IP address and the link won't work.
                  >
                  > Doug
                  >
                  > "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
                  > news:eLqVvKTiEH A.1644@tk2msftn gp13.phx.gbl...[color=green]
                  > > Don't use the hyperlink datatype! Just store 'http://162.136.133.36' in[/color][/color]
                  a[color=blue][color=green]
                  > > text(255) column. Your ASP is going to have to build a link anyway:
                  > >
                  > > ip = rs("IP_Address" )
                  > > response.write( "<a href=" & ip & ">" & ip & "</a>")
                  > >
                  > > --
                  > > http://www.aspfaq.com/
                  > > (Reverse address to reply.)
                  > >
                  > >
                  > >
                  > >
                  > > "Dvan" <dthmtlgod@yaho o.com> wrote in message
                  > > news:#K2GXySiEH A.2544@TK2MSFTN GP10.phx.gbl...[color=darkred]
                  > > > I have a field in my access DB, that is a hyperlink to an IP address.
                  > > >
                  > > > When I display that field on my site using ASP, the link doesn't come
                  > > > across.
                  > > >
                  > > > This is displayed
                  > > > 162.136.133.36#http://162.136.133.36#
                  > > >
                  > > > The code to display the field is below
                  > > > response.write "<TD WIDTH=200>" & vbcrlf
                  > > > response.write( rs("IP_Address" ))
                  > > > response.write "</TD>" & vbcrlf
                  > > >
                  > > > Is there a workaround? I have also tried to make the field a text[/color][/color][/color]
                  field[color=blue][color=green][color=darkred]
                  > > > with HTTP:// in front of the rs("IP_Address" ) and that doesn't work[/color]
                  > > either.[color=darkred]
                  > > >
                  > > > Thanks in advance.
                  > > >
                  > > > Doug
                  > > >
                  > > >[/color]
                  > >
                  > >[/color]
                  >
                  >[/color]


                    Comment

                    Previous template Next
                    Working...