 <% option explicit ---------阿舜作品更新于2001.3.11------------- 数据库结构和上次发表的同样 三级下拉框连动 数据库： location 表1 loaction 所在地表 字段 loactionid （主键） loactionname 名字 表2 district 所在的地区表 字段 locationid （主键） districtid districtname 表3 village 所在的县区表 字段 districtid （主键） villageid villagename %> <% dim conn dim rs dim sql dim count dim rs1 dim sql1 dim rs2 dim sql2 dim count2 set conn=server.createobject("adodb.connection") conn.open"provider=sqloledb;data source=192.168.0.33;uid=sa;pwd=;database=location;" sql = "select * from district order by locationid asc" set rs = conn.execute(sql) %> <%sql2 = "select * from village order by districtid asc" set rs2 = conn.execute(sql2) %> |
喜欢本文，那就收藏到： |
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到POCO网摘"){kind=logo}
Rss Feed
