Transfer multiple values ​​in the drop-down list

TO.ASP ----------------------------------------------- --------- <% new = Split (Request.form ("New"), ",", 2) Response.write "Type =" & New (1) & ", Class =" & New (2)%> -------------------------------------------- -----------

The Form.htm pull-down list is transmitted to a value, but the value is used in two groups of data separated by ','. TO.ASP is a NEW array, two data new (1), New (2), NEW (1)

There are many people who have recently asked the chart, I have made one, I don't have to share itself. I am exactly to everyone. The database structure uses common provinces and cities. The database structure structure comes from 9cbs. You can change it yourself. If you have any comments, please ask, you have to code files and databases, please post and leave email. This article is completely VBS production, makes VBS masters, I can use VBS to make JavaScript can do all QQ: 28963147, Email: Panyuguang962@sohu.com

Access Database ● Database Name: DB_PROVINCAT ● Table Name: 1) TB_PROVINCE 2) TB_CITY Description: Table TB_PROVINCE is used to store the provincial name; table TB_CITY is used to store the corresponding city name. ● Field name design 1) Table TB_Province's field has a provincial ID number (province code), province name (provincename), Table 1 gives example: provinceCatid ProDincename1 01 Beijing 2 02 Shanghai 3 03 Tianjin 4 04 Chongqing 5 05 Guangdong 6 06 Zhejiang 7 07 Fujian 8 08 Hainan 9 09 Jiangsu Province Table 12) Table TB_CITY Field has a city ID (CityID), citycode, city name ( CityName), Table 2 Example: cityid citycode cityname1 01001 Beijing 2 02001 Shanghai 3 03001 Tianjin 4 04001 Chongqing 5 05001 Guangzhou 6 05002 Shenzhen 7 05003 Zhuhai City 8 05005 Maoming City 9 06001, China Hangzhou 11 06002 Wenzhou 12 07001 Fuzhou 13 07002 Xiamen 14 08001 Haikou City 15 08003 Wanning City 17 08004 Wuji Mountain 18 09001 Nanjing 19 09002 Suzhou City

Table 2

Description: One thing to pay attention to here is that the identity code should correspond to the first two digits of the city code, the database does not have a father who has no son. Document: Twosect.asp is easy to use!

<% DIM CN, RSDIM SQL, STRDSN DIM MyArray () SET CN = Server.createObject ("AdoDb.Connection") SET RS = Server.createObject ("AdoDb.Recordset") strdsn = "Driver = {Microsoft Access Driver (* .mdb)}; DBQ = "& Server.mappath (" db_provincecat.mdb ") cn.open strdsnsql =" Select * from tb_province Order by provincecatid "rs.Open SQL, CN, 3, 2RS .MOVEFIRSTREDIM MyArray (rs.recordcount-1)%>