navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Formatting Issue with Access 'hyperlink' field type

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Formatting Issue with Access 'hyperlink' field type 		Page: [1]
 
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		Formatting Issue with Access 'hyperlink' field type - 11/17/2003 12:02:06   
Hey all. Using Access 2000 with FP 2000.

I have a field in my database that is a full hyperlink field. If I click the link in my database I go directly to the link fine.

I also have an online search that displays the same info, but the online link does not work. When the hyperlink is displayed onscreen there is a # sign in front of and after the hyperlink.

<%=FP_FieldVal(fp_rs,"insurance_click")%>

Am I doing something wrong, or could it be some setting on the server? I do not know what is missing? thanks

< Message edited by Spooky -- 11/20/2003 4:50:50 PM >
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/17/2003 13:23:22   
The hyperlink field is designed for office use only - not to be viewed via a web application
Perhpas try to construc the URI as so in the SQL string : 
SELECT id, field2, '<a href=' & Mid([insurance_click],2,Len([insurance_click])-2) & '>' & [insurance_click] & '</a>' AS YourLink FROM table ;


Youll need to tell the DRW the results contain html

<%=FP_FieldHTML(fp_rs,"YourLink ")%>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/17/2003 14:02:39   
"Youll need to tell the DRW the results contain html"

How do I do that?

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/17/2003 14:06:53   
The code I left last should do that :

<%=FP_FieldHTML(fp_rs,"YourLink ")%>

Otherwise, the wysiwyg way of doing it, is to right click on the column value in FP

<<YourLink >> and choose contains html.
Itll change the function to the same as the one above.

Note - ideally for a database web application youll have 2 text fields, one containing the URL, one containing the text to be displayed.
As useful as the "hyperlink' column is in access, its basically a hinderance in asp.

< Message edited by Spooky -- 11/17/2003 2:08:14 PM >

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/17/2003 14:12:20   
I am working with a pre-writtin script someone else set up a long time ago.

If DRW stands for Database Results Wizard (a guess hope I am correct) then there is not one. This was not set up with a Database wizard.

I can send you a copy of the page and you can see the code if it would help Spooky.

I changed my script to look just like the one you provided for that column and no difference.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/17/2003 14:23:45   
I would thing it was a DRW if it has the code "<%=FP_FieldVal(fp_rs,"insurance_click")%> " as above?

Anyway - post it here for a look :)

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 10:23:51   
thanks for the help so far.

I am stumped. I thought it would be easy to figure out, but I have been playing with it for about 4 days now with no luck.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 12:53:24   
Are you able to post what you have?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 14:37:05   
http://www.nationalcompliance.com/download.htm

I can not upload because of my low status, so i just set up a small zip file online that you can download.

The field is "insurance_click" In the database it works perfect, but online it adds the # sign to the front and back of the results.

Thanks.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 14:38:44   
Just cut and paste your source code here, use the "code" button when posting 


CTRL + V to paste your code


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 14:44:21   
Change this line : 

fp_sQry="SELECT * FROM Subform WHERE (ContractorsName LIKE '::ContractorsName::%')"


to : 

fp_sQry="SELECT *,  '<a href=' & Mid([insurance_click],2,Len([insurance_click])-2) & '>' & [insurance_click] & '</a>' AS YourLink FROM Subform WHERE (ContractorsName LIKE '::ContractorsName::%')"



Then change :

<%=FP_FieldVal(fp_rs,"insurance_click")%>

to :

<%=FP_FieldHTML(fp_rs,"YourLink")%>

< Message edited by Spooky -- 11/18/2003 2:45:12 PM >

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to Spooky)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 14:55:44   
Copied your code directly: now the web displays:

Insurance <a href=https://www.nationalcompliance.com/osha/insurance/AAENVIRONMENTAL.tif>#https://www.nationalcompliance.com/osha/insurance/AAENVIRONMENTAL.tif#</a>

where it should only have:

https://www.nationalcompliance.com/osha/insurance/AAENVIRONMENTAL.tif


See....

(in reply to travismp)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 15:27:45   
Try this one :-)

<%=FP_Field(fp_rs,"YourLink")%>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 15:33:48   
This is some crazy stuff. That did it pretty much.... it left the two # signs on the side, but the link does work again....

I am happy with it working so do not worry about the two little # signs, I just put that out there just in case.

You are a smart man. thanks. I will consider this case closed.

What does all of this mean:

<a href=' & Mid([insurance_click],2,Len([insurance_click])-2) & '>' & [insurance_click] & '</a>'

If you have time to teach, if not thianks for all.

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Hyperlink Issue - 11/18/2003 19:06:37   
Try this one to get rid of the # signs 


fp_sQry="SELECT *,  '<a href=' & Mid([insurance_click],2,Len([insurance_click])-2) & '>' & Mid([insurance_click],2,Len([insurance_click])-2) & '</a>' AS YourLink FROM Subform WHERE (ContractorsName LIKE '::ContractorsName::%')"


What its doing, is creating a link from within access as an aliased column value.
Mid() and Len() pull the actual value of "insurance_click" from the database and strip the # from the proprietry Access code.
Youll notice that the <a href> code is normal html.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to travismp)
travismp

 

Posts: 237
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline

  		RE: Hyperlink Issue - 11/20/2003 14:08:46   
That worked perfect. thanks for everything. I am trying to learn as we do this to cut down on the questions. Thanks again.

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Formatting Issue with Access 'hyperlink' field type 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.