Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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
>
>  
>



  Return to Index