[Frogger]

Hi,

I have created an .asp file linked to a .mdb MS access file. The page uses the <select> function where you can select a number of different plants and when this is done it shows the associated plant image which corresponds to the plant name.

It all works fine but I want to change the location of the .mdb file and the .jpg images files. I have worked out how to change the location of the mdb file (from /plants.mdb to Dlink-16a766\volume_1\Plant Database\plants.mdb). I just can work out how to change the new location to where I want to locate the images files. I think it may have something to do wiuth this line of text:

document.getElementById('blank2').src=this.options[this.selectedIndex].value

They use to be in the root directory but I want to change this to a new locationed \\Dlink-16a766\volume_1\Plant Database\

See my code below:

Code:

<img src="\\Dlink-16a766\volume_1\Plant Selection\blank.gif" name="blank1" border="1" width="150" height="150"> 

<select id="list1" onchange="document.getElementById('blank1').src=this.options[this.selectedIndex].value">

        <%
Response.Buffer = true

dim cnn,rst
set cnn = Server.CreateObject("ADODB.Connection")
set rst = Server.CreateObject("ADODB.RecordSet")
cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=\\Dlink-16a766\volume_1\Plant Database\plants.mdb;"


sqltext = "SELECT * FROM plants" _
& " ORDER BY plantname" 


Set RS = cnn.Execute(sqltext)
WHILE NOT RS.EOF

%>
        <option value="<%=RS("filename")%>"><%=RS("plantname")%></option>
        <%
 RS.MoveNext
 WEND
 RS.Close
 cnn.Close
%>
      </select>

Thanks for your help.

[Frogger]

I just worked out how to do this by changing the code this way.

Code:

<option value="[B]\\Dlink-16a766\volume_1\Plant Selection\[B]<%=RS("filename")%>"><%=RS("plantname")%></option>

Cheers everyone