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 4 1491
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" <dt*******@yahoo.com> wrote in message
news:#K**************@TK2MSFTNGP10.phx.gbl... 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
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]" <te*****@dnartreb.noraa> wrote in message
news:eL**************@tk2msftngp13.phx.gbl... 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" <dt*******@yahoo.com> wrote in message news:#K**************@TK2MSFTNGP10.phx.gbl... 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
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>")
-- http://www.aspfaq.com/
(Reverse address to reply.)
"Dvan" <dt*******@yahoo.com> wrote in message
news:uG**************@TK2MSFTNGP09.phx.gbl... 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]" <te*****@dnartreb.noraa> wrote in message news:eL**************@tk2msftngp13.phx.gbl... 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" <dt*******@yahoo.com> wrote in message news:#K**************@TK2MSFTNGP10.phx.gbl... 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
Did you include the http in the href or is it just href=162.136.133.36? If
you include the http, it shouldn't be a problem.
"Dvan" <dt*******@yahoo.com> wrote in message
news:uG**************@TK2MSFTNGP09.phx.gbl... 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]" <te*****@dnartreb.noraa> wrote in message news:eL**************@tk2msftngp13.phx.gbl... 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" <dt*******@yahoo.com> wrote in message news:#K**************@TK2MSFTNGP10.phx.gbl... 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Elaine Jackson |
last post by:
Is there a function that takes a number with binary numeral a1...an to the
number with binary numeral b1...bn, where each bi is 1 if ai is 0, and vice
versa? (For example, the function's value at...
|
by: Brandon J. Van Every |
last post by:
What's better about Ruby than Python? I'm sure there's something. What is
it?
This is not a troll. I'm language shopping and I want people's answers. I
don't know beans about Ruby or have...
|
by: Dan |
last post by:
Is there a python equivalent of this trick in C?
Logic_Test ? True_Result : False_Result
Example:
printf( "you have %i %s", num_eggs, num_eggs > 1 ? "eggs" : "egg" );
|
by: Joseph Garvin |
last post by:
As someone who learned C first, when I came to Python everytime I read
about a new feature it was like, "Whoa! I can do that?!" Slicing, dir(),
getattr/setattr, the % operator, all of this was very...
|
by: Mark Johnson |
last post by:
Oddly enough, I found it difficult, using Google, to find a list of
best-of sites based on the quality of their css packages.
So I'd ask. Does anyone know of particularly good sites which are in...
|
by: Marty |
last post by:
Hi,
I've read that the if/else statement, or get/set accessor, can be
compiled inline by the C# compiler if they are small enough.
Have you seen any documentation that 'summarized' all thoses...
|
by: jaso |
last post by:
Can you give any comments on this code?
I used one goto, is it bad?
#include <stdio.h>
#include <stdlib.h>
#include <ctype.h>
#include <string.h>
#include <assert.h>
#define NOT_NULL 1
|
by: Zhang Weiwu |
last post by:
http://www.w3.org/MarkUp/2004/xhtml-faq provided a trick to serve xhtml
webpage to IE as application/xml
I used that trick and now every one of my xhtml webpage have following
first 4 starting...
|
by: =?Utf-8?B?UmljaA==?= |
last post by:
Hello,
In my vb2005 app I create 3 datatables in the Datasource area, tbl1, tbl2,
tbl3. tbl1 contains 1 column, tbl2 contains 2 columns tbl3 contains 3
columns.
Based on selections from a...
|
by: DR |
last post by:
I heard there is some trick to referencing statics in C# CLR stored
procedure without having to mark the assembly as unsafe. Does anyone know
this? This is usefull as the case of needing a little...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
| |