|
 |
application_development thread: How to retrive URL address in ASP out of databse.
Message #1 by "Claudia" <bchudak@h...> on Thu, 19 Sep 2002 23:49:41
|
|
Hello,
How to retrive URL address in ASP out of databse.
I have created a recordset that holds that value but it will not write to
the screen. My recordset works since I tested with a diffirent value.
So what I need to find out is code of how to display/format ASP in order
to show correctly my URL address on screen.
that field is currently holding values as such www.website.com,
how could I use concatenation in order to add http:// str before
www.website.com.
Thanks in advance for your responses,
Claudia
Message #2 by Melvin Tan <melhuat@p...> on Fri, 20 Sep 2002 11:10:57 +0800
|
|
Hi,
Suppose your recordset is by the variable name of objRS
The following should solve your problem
' Start Of Example
Dim url
url = "http://" + "www.google.com"
Response.write "<A href='" &url &"'>"&URL&"</A>"
' end of Example.
You can replace "www.google.com" with your recordset values For example,
objRS("dbURLString")
Hope it helps.
Good luck
Melvin
Claudia wrote:
>Hello,
>How to retrive URL address in ASP out of databse.
>I have created a recordset that holds that value but it will not write to
>the screen. My recordset works since I tested with a diffirent value.
>So what I need to find out is code of how to display/format ASP in order
>to show correctly my URL address on screen.
>
>that field is currently holding values as such www.website.com,
>how could I use concatenation in order to add http:// str before
>www.website.com.
>
>Thanks in advance for your responses,
>Claudia
>
>
>
|
|
 |