Hi all, I have a drop down list

[garfield11]

Hi all,

I have a drop down list with multiple selection. Let say I selected John,Mary and Johnny and saves into a database. When I click the edit button, how can I make the selected items highlighted?

Example:

Consultant Name: John <-- highlighted
Jane
Mary <-- highlighted
Johnny <-- highlighted
Alan

Thanks.

Love_Garfield

 

[GUJUm0deL]

Do you wanna use JS for the scripting?? It might be easier if you used VBScript, or ASP or SQL (in conjunction with coldfusion)... I have not failed; I have merely found 100,000 different ways of not succeding...

 

[garfield11]

Hi,

Thanks for your reply.

I currently using VBScript.

Here are my code:

<TR><TD valign=&quot;top&quot;>Consultant Name :</TD>
<TD valign=&quot;top&quot;><SELECT name=&quot;Consultant_ID&quot;>
<% While Not objRS3.EOF %>
<OPTION Value=&quot;<%= objRS3(&quot;Consultant_ID&quot %>&quot;
<% If edit <> -1 Then
If objRS3(&quot;Consultant_ID&quot = objRS(&quot;Consultant_ID&quot Then
Response.Write &quot; SELECTED &quot;
End If
End If %> ><%= objRS3(&quot;ConsultantName&quot %></OPTION>
<%
objRS3.MoveNext
Wend %>
</SELECT></TD></TR>

But this only works when I selected 1 item but not more than 1.

Any idea how can I go about doing so??

Thanks!

Love_Garfield