<!--#include file="conn2.asp"--> 
<% 
sql="select * from OtherProperty Order By ID" 
set mrs=conn.execute(sql) 
%> <% if (mrs("PropertyValue")<>"") then 
tmpValue = split(mrs("PropertyValue"),"/") 
else 
dim tmpValue(6) 
for j=0 to 5 
tmpValue(j)="" 
next 
end if 
%><form name="form1" method="post" action="2.asp"> 
<input type="checkbox" name="OtherProperty1" value="<%=tmpValue(0)%>" /> 
<%=tmpValue(0)%> 
<input type="checkbox" name="OtherProperty1" value="<%=tmpValue(1)%>" /> 
<%=tmpValue(1)%> 
<input type="checkbox" name="OtherProperty1" value="<%=tmpValue(2)%>" /> 
<%=tmpValue(2)%> 
<input type="checkbox" name="OtherProperty1" value="<%=tmpValue(3)%>" /> 
<%=tmpValue(3)%> 
<input type="checkbox" name="OtherProperty1" value="<%=tmpValue(4)%>" /> 
<%=tmpValue(4)%> 
<input type="checkbox" name="OtherProperty1" value="<%=tmpValue(5)%>" /> 
<%=tmpValue(5)%> 
<input type="submit" name="Submit" value="确定"> 
写入代码是： 
<!--#include file="conn2.asp"--> 
<% 
OtherProperty1=request.form("OtherProperty1") 
sql="insert into product(OtherProperty1)values('"+OtherProperty1+"')" 
conn.execute sql 
'response.write sql 
'response.end 
response.Write "<script language=javascript>alert('添加成功！');history.go(-1);</script>" 
response.End 
%> 
这样的话是正常的，我要这么写的话 
sql="Insert into product(name,mark,introduce,price1,price2,price3,price4,price5,price6,vipprice,spic,pic,categoryid,productdate,discount,score,stock,grade,type,recommend,Supplier,detail,code,pweight,OtherProperty1,adddate,solded,viewnum,rank,ranknum) values('"&trim(request.form("name"))&"','"&trim(request.form("mark"))&"','"&trim(request.form("introduce"))&"',"&trim(request.form("price1"))&","&trim(request.form("price2"))&","&trim(request.form("price3"))&","&trim(request.form("price4"))&","&trim(request.form("price5"))&","&trim(request.form("price6"))&","&trim(request.form("vipprice"))&",'"&trim(request.form("spic"))&"','"&trim(request.form("pic"))&"',"&trim(request.form("categoryid"))&",'"&productdate&"',"&discount&","&trim(request.form("score"))&","&trim(request.form("stock"))&",'"&trim(request.form("grade"))&"','"&trim(request.form("type"))&"','"&trim(request.form("recommend"))&"','"&trim(request.form("Supplier"))&"','"&strDetail&"','"&trim(request.form("code"))&"','"&trim(request.form("pweight"))&"',"+OtherProperty1+",'"&now&"',0,0,0,0)" 
conn.execute sql 
response.Write "<script language=javascript>alert('添加成功！');history.go(-1);</script>" 
response.End 

就不正常，怎么改才能正常呀。 
name,mark,introduce,price1,price2,price3,price4,price5,price6,vipprice,spic,pic,categoryid,productdate,discount,score,stock,grade,type,recommend,Supplier,detail,code,pweight,OtherProperty1,adddate,solded,viewnum,rank,ranknum 这些是我数据库表的名称。