表单数据提交数据库的问题，请指教！
各位好，麻烦大家看一下我将a.asp中的下拉框的值插入到数据库中时是空值，这是怎么回事？烦请大虾们给指导一下哈！不胜感激！
a.asp
<form name="myform" method="post" action="b.asp">
<select name="select">
<option value="s">2</option>
</select>
</form>
<input type="submit" name="Submit" value="提交">
b.asp
<form name="form1" method="post" action="a.asp">
</form>
<%
set conn=server.createobject("adodb.connection")
conn.open"provider=sqloledb;data source=hp;uid=sa;pwd=shangfj;database=www;"
dim str,str_sql
str=request.form("select")
str_sql="insert into table1(field1) values('"&str&"')"
conn.execute str_sql
conn.close
set conn=nothing
%>
问题点数：50、回复次数：7Top
1 楼ronakitty（毓苫）回复于 2005-03-05 19:21:53 得分 10
<form name="myform" method="post" action="b.asp">
<select name="select">
<option value="s" selected>2</option>
</select>
</form>Top
2 楼liuxiaoyi666（MSMVP 小猪妹荣誉马甲之八卦兔子）回复于 2005-03-05 20:26:47 得分 10
程序没错不过你选择过了么?/
可以RESPONSE.WRITE REQUEST.FORM("SELECT")
检查一下Top
3 楼sfply（随风飘零叶）回复于 2005-03-05 20:50:54 得分 10
select是关键字，换一个名字看看Top
4 楼hubingbin（胡兵斌）回复于 2005-03-05 20:54:35 得分 20
==================================================================
<form name="myform" method="post" action="b.asp">
<select name="select">
<option value="s">2</option>
</select>
</form>
<input type="submit" name="Submit" value="提交">
==================================================================
你的提交按钮不在你的form里面啊
换成下面的看看
<form name="myform" method="post" action="b.asp">
<select name="select">
<option value="s">2</option>
</select>
<input type="submit" name="Submit" value="提交">
</form>
Top
5 楼shangfj（shangfjlenovo）回复于 2005-03-05 21:01:50 得分 0
我改过了，把提交按钮放在表单里就行了，谢谢大家！Top
6 楼shangfj（shangfjlenovo）回复于 2005-03-05 21:06:45 得分 0
本贴已结贴Top
7 楼shangfj（shangfjlenovo）回复于 2005-03-05 21:09:42 得分 0
怎么给分阿？对不起不太会？Top
