Retrive the items in list box

[Amit Shinde]

I have multiple list box added to the asp page using <select> tag

I have added items in the list box using recrdset from Education table
Education table={educationid, educationname}

User can choose more than items from the list box. These items gets
added in the user table in field
"edu" seprated by commas.
When User wants to edit his information ...i want that the items in the
list box should be automatically selected which are present in "edu"
field.
Please help
Amit shinde

 

[Dominique]

dim strEdu
strEdu = field_value_in_db 'get it from ur recordset

function select_field(eID)
if instr(1, strEdu, eID) then
select_field = " selected"
end if
end function

call the function above when ur looping through the recordset to create the
list again...

do until rs.eof %>
<option value="<%=rs("educationid")%>"
<%=select_field(rs("educationid"))%>><%=rs("educationname")%></option>
<%
rs.movenext
loop