SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Nov 2012
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need help resetting filepath on multiple fields

    This is my first post, and I'm hoping this is an easy question for someone.

    I have the code below. I'm trying to have both fields "Uploaded Photo" and "Additional Photo 1" show on a page with the paths corrected. With this code the only item showing is the last item "Additional Photo 1". The last filepath defined is the only one showing up. How do I get my results to show all (and there will be more - I have 8 additional photo fields that I will need to add)?
    <%
    filepath=rs("Uploaded Photo")

    if Len(filepath)>0 then
    pos=instr(filepath , "..")
    if pos>0 then
    do while pos>0
    filepath=mid(filepath,(pos+2))
    pos=instr(filepath , "..")
    loop
    end if
    filepath="<a href='http://www.mysite.com" & filepath & "</a>"
    end if
    %>
    <br>
    <%
    filepath=rs("Additional Photo 1")

    if Len(filepath)>0 then
    pos=instr(filepath , "..")
    if pos>0 then
    do while pos>0
    filepath=mid(filepath,(pos+2))
    pos=instr(filepath , "..")
    loop
    end if
    filepath="<a href='http://www.mysite.com" & filepath & "</a>"
    end if

    Thanks!

  2. #2
    SitePoint Enthusiast
    Join Date
    Jan 2012
    Posts
    45
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The problem is that you are repeatedly setting the values to the "filepath" variable for both the paths. Assign the path of each photo to different variables .

    And there could be a better way to remove the ".." in the path than what you are doing right now..

    Can you show the values of paths you will be starting with ?

  3. #3
    SitePoint Member
    Join Date
    Nov 2012
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you very much! I had tried that and it didn't work, but after looking at the code again, there was another line where it was calling in filepath - so I just had to add the additional filepath1, filepath2, etc. Now it is working. To answer your other question, the path is dynamically generated. The photo it is calling in is in the database as ../folder1/photo.jpg - so the path changes depending on where I am pulling it in from.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •