(1)
<% Set ItemRs = server. createObject ("adodb. recordset ") ItemSql =" select * from Howia_SuggestionSort "ItemRs. open ItemSql, conn, 1, 3if ItemRs. eof and ItemRs. bof then Response. write ("No information") elseResponse. write ("<select name =" "SelectItem" "id =" "BigID" "style =" "width: 200px;" "onchange =" "ClassChange (this. value) ""> ") Response. write ("<option value =" "0" "selected> select a Category </option>") do while not ItemRs. eof %> <option id = "Sledcom" name = "Sledcom" value = "<% = ItemRs (" BigID ") %>"> <% = ItemRs ("SortName ") %> </option> <% ItemRs. movenext loop Response. write ("</select>") ItemRs. close set ItemRs = nothing end if %>
(2)
Hide the uploaded values
(3)
<script type="text/javascript">function ClassChange(locationid){ document.getElementById('Keyword').value = document.getElementsByTagName("option")[document.getElementById("SelectItem").selectedIndex].value;}</script>