求救!我想从一个form里返回多个复选筐的值

就是选中的按确定后到从数据库里显示出以复选筐值为name的一行数据,
但是不知道怎么循环,只能一个一个的判断,能不能用循环?
---------------------------------------------------------------

比如你的复选框如下:

1<input name="chk" type="check" value="1"/>
1<input name="chk" type="check" value="2"/>
1<input name="chk" type="check" value="3"/>
1<input name="chk" type="check" value="4"/>

现在选中了1,3,4

你现在数据库中找出符合条件等于1,3,4的记录,可以这样写:

chkvalue = Request.Form("chk")

sql = "select * from yourtable where yourfield in (" & chkvalue & ")"

rs.open sql,conn,3,1

如果你的这个字段的类型为字符型,则需要把
chkvalue = Request.Form("chk")
改成
chkvalue = Replace(Request.Form("chk"),",","','")

然后把
sql = "select * from yourtable where yourfield in (" & chkvalue & ")"
改成
sql = "select * from yourtable where yourfield in ('" & chkvalue & "')"

---------------------------------------------------------------

name要相同,Request("thename")取到的就是所有选中的value的数组!
---------------------------------------------------------------

好象是空格做怪
你用replace把空格过滤掉试试
---------------------------------------------------------------

temp = Request.Form("selectName")

sql = "select * from yourtable where name='"&temp&"'"
rs=conn.Execute(sql)
Do while Not rs.EOF
Response.Write rs(0)
rs.MoveNext
Loop

最后的答案
chkvalue = Replace(Request.Form("chk"),",",",")
chkvalue = Replace(Replace(chkvalue," ",""),",","','")
sql = "select * from sales where 姓名 in('" & chkvalue & "')"
Response.Write chkvalue
rs.open sql,conn,3,1

Published At
Categories with Web编程
Tagged with
comments powered by Disqus