Source: Unknown Author: Unknown Recommended rating: Visits: 15
On the Internet, you often have a post on the linkage menu, and you will post your code, for university participation. Database: Table 1: Region (ID, province) Table 2: CITY (ID, city, province) II. Code implementation: <% function dbcombox () DIM RS, SQL, MSG SQL = "SELECT * from region" set = conn.execute (SQL) While NOT rs.eof msg = msg & "" "" "") & "" "" ") &" "rs.Movenext Wend Rs.Close Set RS = Nothing dbcombox = msg End function%>
city"> city (); <% DIM RS, SQL, I SQL = " Select * from city "set = conn.execute (sql) i = 0 while not ==%%> citys [<% = i%>] = new array (" "<% = rs (" province ")%>" "<% = rs (" city ")%>"); <% i = i 1 rs.Movenext Wend Rs.close set = Nothing%> Function Changeselect (SelValue) {var selValue = sleelue; var. Document.form1.city.length = 0; Document.form1.city.Options [Document.form1.city.leng TH] = New Option ("Please select", ""); for (i = 0; i
<
