当前页面: JAVA 编程资料牛鼻论坛 → J2EE Datebase 数据库开发→asp中如何实现八个复选框最多只能选择三个且其值提交到数据库 |
先判断下数据类型是否正确,再写入数据库
IF isNumeric(a) and isNumeric(b) and isNumeric(c) Then
rs("cgxs1")=a
rs("cgxs2")=b
rs("cgxs3")=c
Else
Response.Write "数据类型错误"
End IF
不过如果别人选了五个选项你如何取三项.
<form name="form3" method="get" action="list.asp">
<input type="checkbox" name="cat" value="1" onClick="return totalcat();">1
<input type="checkbox" name="cat" value="2" onClick="return totalcat();">2
<input type="checkbox" name="cat" value="3" onClick="return totalcat();">3
<input type="checkbox" name="cat" value="4" onClick="return totalcat();">4
<input type="checkbox" name="cat" value="5" onClick="return totalcat();">5
<input type="checkbox" name="cat" value="6" onClick="return totalcat();">6
<input type="checkbox" name="cat" value="7" onClick="return totalcat();">7
<input type="checkbox" name="cat" value="9" onClick="return totalcat();">9
<input type="text" name="catsum" value="0">
</form>
<script language="javascript">
//<!--
function totalcat(){
var j=0;
for(i=0;i<8;i++){
if(form3.cat(i).checked==true){j++}
}
if(j>3){
alert("最多只能选择三个分类");
return false;
}else{
form3.catsum.value = j;
}
}
//-->
</script>
为什么不在客户端限制只能选择3条信息呢?
<SCRIPT language=Javascript>//<!--
function CheckAll(form){
form.selectsum.value=0;
for (var i=0;i<form.elements.length;i++){
var e = form.elements[i];
if (e.name == 'TopicID'){
e.checked = form.chkall.checked;
if(e.checked){form.selectsum.value++};
}
}
}
function selectindex(select,selectvalue){
cpid_i = 0;cpid_j = 0;
for (cpid_i=0;cpid_i<select.length;cpid_i++){
if( select.options[cpid_i].value == selectvalue )
{cpid_j = cpid_i;break;}
}
select.selectedIndex=cpid_j;
return cpid_j;
}
//-->
</SCRIPT>
<FORM name=approve action=?com=send method=post>
<META content="MSHTML 6.00.2800.1555" name=GENERATOR>
<TABLE cellSpacing=0 cellPadding=2 width="100" border=0>
<TBODY>
<TR>
<TD width=100>推荐信息</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=1>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=2>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=3>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=4>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=5>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=6>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=7>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=8>
</TD>
</TR>
<TR>
<TD width=40>
<INPUT
onclick=i=selectsum.value;if(this.checked){selectsum.value++}else{selectsum.value--}
type=checkbox name=pub value=9>
</TD>
</TR>
</TBODY>
</TABLE>
<BR><BR>
<DIV align=center><INPUT type=hidden name=operate> <INPUT class=stedit
type=hidden size=2 value=0 name=selectsum> <INPUT onclick="javascript:if(selectsum.value!=3){alert('请选择3条数据!')}else if(confirm('是否将设定的数据进行操作\n\n提醒:当前操作不能复原!')){approve.operate.value='update';approve.submit();};" type=button value=提交>
</DIV>
</form>