checkbox返回值的问题

1   
2  
3if(request.form("checkbox") <> "") then Command1__MM_id = request.form("checkbox")   
4  
 1   
 2  
 3set Command1 = Server.CreateObject("ADODB.Command")   
 4Command1.ActiveConnection = MM_conn_STRING   
 5Command1.CommandText = "UPDATE dbo.tblFaxInformation SET status = 2 WHERE ID = " + Replace(Command1__MM_id, "'", "''") + " "   
 6Command1.CommandType = 1   
 7Command1.CommandTimeout = 0   
 8Command1.Prepared = true   
 9Command1.Execute()   
10  

代码如上,我要返回多个checkbox,就是一组中的几个,但是在测试时
选种一个能完成,选种多个就不行了,为什么?
---------------------------------------------------------------

多个checkbox不要同名
---------------------------------------------------------------

选中多个,返回值就是一个数组了,你要用split()函数把返回值分开;
或者修改一下SQL语句
Command1.CommandText = "UPDATE dbo.tblFaxInformation SET status = 2 WHERE ID IN ("&Command1__MM_id&")"

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

选中多个CHECKBOX的时候会以字符串的形式返回,各个值之间用逗号隔开。
只需用SPLIT()将其分割成数组再操作就可以了。

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