Access97, spaces and Netscape... What a headache!!!

[Paragod2000]

What we have is a details page pulling info from an Access97 database. One of the things it pulls out is the location of a photo to be displayed. (/images/my folder/my first pic.jpg) To this location we add an SRC tag and we have dynamic picture. See code below. Well, this works fine for Internet Explorer, but Netscape can not support spaces the spaces in the name. What we are looking for is some way so that we may display the pics in Netscape without having to rename all of them and then go into the database and make all of the address changes.


<img src=&quot;<%=(Recordset1.Fields.Item(&quot;Photo2Name&quot.Value)%>&quot;>
<br>
<%=(Recordset1.Fields.Item(&quot;Photo2Title&quot.Value)%>

Where Photo2Name is a hyperlink field holding location of the picture (/images/my folder/my first pic.jpg) and Photo2Title is a text field.


If anyone can think of anything that might help us, we would be most gratefull.

Thanks,
Tom

 

[hblackorby]

When you write out your hyperlink do server.URLencode(&quot;imagename&quot this will automatically convert spaces to %20 so they work in NS and in IE. IE automatically converts spaces to %20 on the fly.

You can also do:
imagename = replace(imagename,&quot; &quot;,&quot;%20&quot
if you want

Hope that helps. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[Paragod2000]

Could you possibly give me an example using the code from above? Not sure exactly what you mean to put it...

Thanks,
Tom