Convert Physical path to Virtual path?

[Scott Tilton]

We have a field that gets filled into a database that our ASP website pulls
from. What we would like to be able to do is to take that path and convert
it to a virtual path so the website can display the image. We have setup
with our website a virtual directory for: "g:\quotewerks\images\" which is
[url]http://www.ourwebsite/images[/url].

So, below you can see the data we pull from the field in the database, and
what I need it to look like. Can anyone help me out with the code to do
this?

From database:

q:\quotewerks\images\contact systems\contac3s.jpg
q:\quotewerks\images\fuji\cp6-5 cal\mvc-012f(2).jpg
q:\quotewerks\images\front emerald.jpg

Needs to be changed to:

/images/contact systems/contac3s.jpg
/images/fuji/cp6-5 cal/mvc-012f(2).jpg
/images/front emerald.jpg


Any help would be great, thanks!

Best Regards,

Scott B. Tilton

Avantek Services
Phone: (603)742-1333 Ext. 26
Fax: (603)299-0323
[email]stilton@avantekservices.com[/email] or [email]stilton@avsv.com[/email]
[url]www.avantekservices.com[/url] or [url]www.avsv.com[/url]

"A focused mind is the ultimate weapon." - Unknown

** Support Cancer Research: [url]http://www.rosepedal2003.com[/url] **

[Aaron Bertrand - MVP]

path = "q:\quotewerks\images\front emerald.jpg"
path = replace(replace(path, "q:\quoteworks", ""), "\", "/")
response.write path


"Scott Tilton" <stilton@avantekservices.com> wrote in message
news:OgJek47RDHA.3192@TK2MSFTNGP10.phx.gbl...

> We have a field that gets filled into a database that our ASP website

pulls

> from. What we would like to be able to do is to take that path and

convert

> it to a virtual path so the website can display the image. We have setup
> with our website a virtual directory for: "g:\quotewerks\images\" which

is

> [url]http://www.ourwebsite/images[/url].
>
> So, below you can see the data we pull from the field in the database, and
> what I need it to look like. Can anyone help me out with the code to do
> this?
>
> From database:
>
> q:\quotewerks\images\contact systems\contac3s.jpg
> q:\quotewerks\images\fuji\cp6-5 cal\mvc-012f(2).jpg
> q:\quotewerks\images\front emerald.jpg
>
> Needs to be changed to:
>
> /images/contact systems/contac3s.jpg
> /images/fuji/cp6-5 cal/mvc-012f(2).jpg
> /images/front emerald.jpg
>
>
> Any help would be great, thanks!
>
> Best Regards,
>
> Scott B. Tilton
>
> Avantek Services
> Phone: (603)742-1333 Ext. 26
> Fax: (603)299-0323
> [email]stilton@avantekservices.com[/email] or [email]stilton@avsv.com[/email]
> [url]www.avantekservices.com[/url] or [url]www.avsv.com[/url]
>
> "A focused mind is the ultimate weapon." - Unknown
>
> ** Support Cancer Research: [url]http://www.rosepedal2003.com[/url] **
>
>

[Dhananjay Modak]

One way is:
- read physical path
- use combination of mid and instr functions to find the 2nd slash
- cut the string at the 2nd slash (assumption: first directory is the root
of the web site)

cheers
Dhananjay

"Scott Tilton" <stilton@avantekservices.com> wrote in message
news:OgJek47RDHA.3192@TK2MSFTNGP10.phx.gbl...

> We have a field that gets filled into a database that our ASP website

pulls

> from. What we would like to be able to do is to take that path and

convert

> it to a virtual path so the website can display the image. We have setup
> with our website a virtual directory for: "g:\quotewerks\images\" which

is

> [url]http://www.ourwebsite/images[/url].
>
> So, below you can see the data we pull from the field in the database, and
> what I need it to look like. Can anyone help me out with the code to do
> this?
>
> From database:
>
> q:\quotewerks\images\contact systems\contac3s.jpg
> q:\quotewerks\images\fuji\cp6-5 cal\mvc-012f(2).jpg
> q:\quotewerks\images\front emerald.jpg
>
> Needs to be changed to:
>
> /images/contact systems/contac3s.jpg
> /images/fuji/cp6-5 cal/mvc-012f(2).jpg
> /images/front emerald.jpg
>
>
> Any help would be great, thanks!
>
> Best Regards,
>
> Scott B. Tilton
>
> Avantek Services
> Phone: (603)742-1333 Ext. 26
> Fax: (603)299-0323
> [email]stilton@avantekservices.com[/email] or [email]stilton@avsv.com[/email]
> [url]www.avantekservices.com[/url] or [url]www.avsv.com[/url]
>
> "A focused mind is the ultimate weapon." - Unknown
>
> ** Support Cancer Research: [url]http://www.rosepedal2003.com[/url] **
>
>