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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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("educat ionname")%></option>
<%
rs.movenext
loop

"Amit Shinde" <am*******@yahoo.com> wrote in message
news:OU**************@TK2MSFTNGP09.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!