\[code\]<html><title>Test</title><body bgcolor="FFFFFF"><%Set conn = Server.CreateObject("ADODB.Connection")conn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=123;Data Source=1234"Set rs = Server.CreateObject("ADODB.Recordset")SQL = "select * from 1234"rs.open SQL, connresponse.write("<table border='1'>")While Not rs.EOFresponse.write("<tr><td>" & rs("Name") & "</td><td>" & rs("PID") & "</td><td>" & rs("Coords") & "</td><td>" & rs("Items") & "<select size='3' name='itemlist'>Array through option tags here????</select></td></tr>")rs.MoveNextWendresponse.write("</table>")rs.closeconn.closeSet rs = NothingSet conn = Nothing%></body></html>\[/code\]My rs("Items") contains many comma delimited values, I'd like to add each item to the listbox. Can someone point me in the right direction? thanks!
populate listbox in asp with a comma delimited array
- Thread starter hosam2
- Start date