How can i link a file with a space in FP/ASP?

[jackle_usmc]

I have a page that runs a query on a sql database. A table contains
the location of images. The name of some of the images contains
spaces. I know that when you have pages/links you don't use spaces.
My problems is that I cannot do anything about the way the file names
when they are inserted into the database.

When you click on the link you cannot view the image because IE
interepets the space as a %20. If the image does not have a space in
it then the links work perfectly fine.

 

[Jens Peter Karlsen [FP-MVP]]

Rename the images and update the database to reflect the new names.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[Thomas A. Rowe]

The best option is to follow Jen's advice!

However, you can use Server.URLEncode as a workaround, see
http://www.kamath.com/codelibrary/cl006_url.asp

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Mike Mueller]

For the db, you can use a search & replace query to find the
spaces and replace them with underscores or hyphens. You
would want to do the same with the image files of course.


message : Rename the images and update the database to reflect the
new names.
:
: Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
:
: On 20 Dec 2006 21:35:09 -0800, (e-mail address removed)
wrote:
:
: >I have a page that runs a query on a sql database. A
table contains
: >the location of images. The name of some of the images
contains
: >spaces. I know that when you have pages/links you don't
use spaces.
: >My problems is that I cannot do anything about the way
the file names
: >when they are inserted into the database.
: >
: >When you click on the link you cannot view the image
because IE
: >interepets the space as a %20. If the image does not
have a space in
: >it then the links work perfectly fine.