就是选中的按确定后到从数据库里显示出以复选筐值为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