a hyperlink in the database result

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

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

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

Recent Posts

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

a hyperlink in the database result

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 >> a hyperlink in the database result

Page: [1]

harrington

Posts: 4
Joined: 12/10/2004
Status: offline

a hyperlink in the database result - 12/10/2004 12:56:55

Hello,
I have been looking and searching at previous posts, and trying many things, but I really do not understand this. Hope somebody can help. I have the database results, but I want to convert one of the fields (the website field) into a link. This is the code for that specific field without any links:

<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,DateModified,LoanType,Rate,Points,APR,Company,Website,Phone,Email,Password" s-column="Website" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Website<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Website")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13439" -->

The problem is, instead of just leaving my site and going directly to the link address, it goes into error because it goes into: my url address/url of the link where I want it to go.

If I double click on the field, I get a "Database column value" and if I choose "Display as hyperlink, this is the code:

<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,DateModified,LoanType,Rate,Points,APR,Company,Website,Phone,Email,Password" s-column="Website" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="TRUE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font><a href=".">Website</a><font size="-1">&gt;&gt;</font>" startspan --><%="<a href=""" & FP_FieldLink(fp_rs,"Website") & """>" & FP_FieldVal(fp_rs,"Website") & "</a>"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16432" -->

Something else I tried:
I remove the previous code (2nd), and I right clicked on the field, inserted a hyperlink and add the parameter, this is the code:

<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,DateModified,LoanType,Rate,Points,APR,Company,Website,Phone,Email,Password" s-column="Website" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Website<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Website")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13439" -->

both ways still go to my url and writes the link after my url going into error.
I read previous posts on changing & FP_FieldURL into & FP_FieldValue, and I also read posts on Redirect.Write, but I guess I am not writing in the correct place.
If somebody can help, I appreciate it. Thanks!


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: a hyperlink in the database result - 12/10/2004 13:23:04 Hi and Welcome to Outfront. I'm not sure why FP is pooching your link. WHat I'm quite certain will work is if you put the DRW on a diet, you should be able to just use something like: <a href="<%=FP_Field(fp_rs,"Website")%>">Click</a> or something to that effect. That's how I do it. If you're not familiar with the diet; http://www.outfront.net/spooky/adv_drw_diet.htm Hope it helps. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to harrington)


dpf Posts: 7126 Joined: 11/12/2003 From: India-napolis Status: offline	RE: a hyperlink in the database result - 12/10/2004 13:28:28 quote: pooching is that an ASP term? (hehe) _____________________________ Dan (in reply to rdouglass)


harrington Posts: 4 Joined: 12/10/2004 Status: offline	RE: a hyperlink in the database result - 12/10/2004 14:50:06 Thanks rdouglass, I guess my code will be soon in a diet! I did tried your code, but it still does the same thing: my url plus the link url and it goes into error. I tried changing the result and wrote a working link instead, www.aol.com, and it stills goes to: http://my url/www.aol.com and it goes into error. Does anybody knows why is doing that? Thanks! < Message edited by harrington -- 12/11/2004 8:51:02 > (in reply to dpf)


harrington Posts: 4 Joined: 12/10/2004 Status: offline	RE: a hyperlink in the database result - 12/12/2004 7:51:25 OK, I figured out the problem (and it is very embarrassing that it took me like 3 days to figure it out) and just in case somebody ends up having the same problem here it is: just add http:// to rdouglass code: <a href="http://<%=FP_Field(fp_rs,"Website")%>">Click</a> (in reply to harrington)