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  1507 
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*******@yaho o.com> wrote in message
news:#K******** ******@TK2MSFTN GP10.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*****@dnartr eb.noraa> wrote in message
news:eL******** ******@tk2msftn gp13.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*******@yaho o.com> wrote in message
news:#K******** ******@TK2MSFTN GP10.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*******@yaho o.com> wrote in message
news:uG******** ******@TK2MSFTN GP09.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*****@dnartr eb.noraa> wrote in message
news:eL******** ******@tk2msftn gp13.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*******@yaho o.com> wrote in message
news:#K******** ******@TK2MSFTN GP10.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.13 3.36? If
you include the http, it shouldn't be a problem.
"Dvan" <dt*******@yaho o.com> wrote in message
news:uG******** ******@TK2MSFTN GP09.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*****@dnartr eb.noraa> wrote in message
news:eL******** ******@tk2msftn gp13.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*******@yaho o.com> wrote in message
news:#K******** ******@TK2MSFTN GP10.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 18 would be 13
.) I thought this was what the tilde operator (~) did, but when I
went to try it I found out that wasn't the case. I discovered by experiment (and
verified by looking at the documentation) that the tilde operator takes n
to -(n+1)....
|
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 any preconceived ideas about it. I have
noticed, however, that every programmer I talk to who's aware of Python is
also talking about Ruby. So it seems that Ruby has the potential to compete
with and displace Python. I'm curious on what basis it...
|
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 different from C.
I'm curious -- what is everyone's favorite trick from a non-python
language? And -- why isn't it in Python?
Here's my current candidate:
So the other day I was looking at the language Lua. In Lua, you make a
|
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
good measure because of their creative and useful css designs? I'm
aware of Zen Garden and a few others. So don't bother with those. And
I hope I don't get replies from people with a 'tin ear' and no design
sense. Good sites. Good pages. That's...
| | |
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
optimizations tricks? I would like to be aware of all tips and trick
that should be used as good programming habits that make any software
coding optimized. I remember that in VB6 there was a lot of
optimization tips.
|
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 lines:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="curseIE.xsl"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
|
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 form, I want to populate on 1 of the 3 tables
with data and use the selected table throughout some procedure - the table
and the data that it contains will have to persist throughout the life of the
application. So instead of having a bunch of...
|
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 static shared variable
here and there without having to compromise safety in the Sql Server 2005.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
