各位大侠帮帮小弟,谢了~
我的数据库有 是/否字段,在提交表单时不填就会错,但是我已在库里面设了,可以为空的。z1,z2,z3,z3,z4,z5,z6,z7这几个是是/否字段,没填就错,有填就不会,那我现在要怎么办?
<%@LANGUAGE="JAVASCRIPT"%>
<% Response.Buffer=true%>
<!--#include file="connjs.asp" -->
<%
var str_field="zhanghao,password1,password2,geren,qiye,fygs,xinmin,xinbei,nian,rye,ren,zjlx,zjhm,gujia,city,txdz,post,gzdw,dwdz,gzzt,telhome,teldw,souji,qq,email,sqlx,yfdn,computer,muyu,dffy,yyahao,schoole,sxzy,zylb,zyxl,bysj,xz,zyxs,yz1,sp1,yz2,sp2,ks1,ks2,cj2,book1,cbs1,cbsj1,book2,cbs2,cbsj2,czpt,bglj,hyly1,hyly2,kysj,gcyq,rwcl,kybcyq,z1,z2,z3,z3,z4,z5,z6,z7,fyjl,dbzp,gzjl,qita,time";
var ary1=str_field.split(",");
var len=ary1.length;
var ary2=new Array(len);
for(var i=0;i<len;i++)
{
ary2[i]="Request.Form(\"" + ary1[i] + "\")";
}
var rs=Server.CreateObject("ADODB.Recordset");
var sql;
sql="select * from yiyatrans";
rs.Open(sql,conn,1,3);
rs.AddNew();
for(var i=0;i<len;i++)
{
eval(("rs(\"" + ary1[i] + "\")=" + ary2[i] + ";"));
}
rs.Update();
%>