[Shankarandy]

Hi..
I'm trying retrieve data from database to list box..
I'm using macromedia dreamweaver, Asp coding and java script.
this is what I have done so far..but i failed to retvieve..
pls correct this..

HTML Code:

 <select name="address" onChange="reloadPage" class="logintext">
	 <%mysql="select distint(address) from customer" 
	 set rs=conn.execute(mysql) 
	 while not rs.eof%>
	 <option value="<%=rs("address")%>"><%=rs("address")%></option>
	 <% rs.movenext%><%wend%>
	 </select>

Thank you

give this a spin
http://w3schools.com/sql/sql_select.asp

[blake]

You were close, but first you need to connect to the database, and after wards you should close everything down to preserve system resources...

Take a look at: This example I posted - it connects using ADO...