Hi,
I have an employee directory in an Access Db. Typical columns include First_Name, Last_Name,...

I've created a dynamic table which lists all the employees... so far so good.
My problem is when I try and retreive a picture of an employee using FSO.

Here the meat of my code calling the jpg:

************************************************** *****************
<%
Set fso = CreateObject("Scripting.FileSystemObject")
Dim PICurl

PICurl="/DB/EmployeePics/" & replace(rsDirectory("First_Name"),"-",("Last_Name")) & ".jpg"


strpath=Server.MapPath(PICurl)%>
      <td align="center" nowrap>
     <%If (fso.FileExists(strpath)) Then%> <a href="<%=PICurl%>" target="_blank" class="docs"><img src="../img/EMPpic.jpg"></a>
         <% Else
        response.write("<P class=""docs"">no pic</P>")
    End If
    %>
************************************************** *****************

My path works fine. I think its in the way (syntax) I call each jpg.
You see, here's my file naming convention for those pics:

Firstname-Lastname.jpg

ie: john-smith.jpg

Please help,

Thanks,
 nancy

And what's the problem you're experiencing?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks Imar, you've alays been very good at responding to my requests in a very speedy fashion. I appreciate it.

To be frank, I have set the images with the filenaming convention mentioned earlier, but all I get as results is "no pic", in that column instead of having the "Hot" image to click on in order view that picture.

What could it be?

Try this:

strpath = Server.MapPath(PICurl)

Response.Write("Physical filename is " & strpath & "<br />")
Response.Write("Virtual filename is " & PICurl& "<br />")
%>

What does it say? Does the first location represent an existing file?

And what happens when you add http://YourServer in front of the second Response.Write output and paste that in a browser? Can you browse to the image?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar,
 I never thought of troubleshooting this way... thanks for the tip!

Here's the results:

Physical filename is E:\Inetpub\INTRANET\DB\EmployeePics\Allan.jpg
Virtual filename is /DB/EmployeePics/Allan.jpg

Briefly both are correct (I think). I think the error resides in "reading" the First_Name of the filenaming convention, not the full name separated by a hyphen as stipulated in previous thread.

We're almost there!
Imar could you look into my syntax above It is always confusing for me to do "ASP- replace..."

Thanks again,
nancy

Right, I see now what you mean with Replace.

Why are you using that in the first place? (no pun intended)

Try this instead:

PICurl="/DB/EmployeePics/" & rsDirectory("First_Name") & "-" & ("Last_Name") & ".jpg"

This contatenaes the first name, a hyphen,,the last name and .jpg so you end up with

john-smith.jpg

which is what you're after, I think.

What was the idea behind using Replace?

Imar