鹰眼战神小说张钧txt:asp中ac数据库问题,值为什么存不进数据库

来源:百度文库 编辑:高考问答 时间:2024/05/01 03:57:08
实现目的:
js控制两级分类,一级字段zc,二级字段zcmc
代码如下---
<SCRIPT language=JavaScript>
var zcmc = new Array(
new Array("标准型驾驶室","高顶型驾驶室","加长型驾驶室","半高顶驾驶室"),
new Array("前轴总成","8×4转向前轴","刚性前轴制动器","刚性前轴转向横拉杆"),
new Array("豪沃1667驱动桥","后驱动桥总成","后桥壳","中桥壳","后桥驱动装置","中桥驱动装置","轮边行星减速器","后制动器"),
new Array("wd615发动机","wd618发动机","斯太尔wd615(02FDJ001)","斯太尔wd615(02VG001)"),
new Array("离合器及操纵装置"),
new Array("变速箱及操纵装置","STR-ZF变速箱"),
new Array("传动轴","斯太尔王4*2 6*2","斯太尔王6*4 8*4"),
new Array("前悬挂系统","前悬架4*2,6*4","前悬架8*4","后悬架4*2","平衡悬架6*4,8*4","4*2,6*4前稳定杆与减振器","8*4前稳定杆与减振器","4*2,4*4后减振器","4*2后稳定器"),
new Array("后县挂系统","前悬架4*2,6*4","前悬架8*4","后悬架4*2","平衡悬架6*4,8*4","4*2,6*4前稳定杆与减振器","8*4前稳定杆与减振器","4*2,4*4后减振器","4*2后稳定器"),
new Array("底盘电器"),
new Array("制动元器件","制动元器件及管路"),
new Array("转向系统","转向操纵机构ZX01A","转向操纵机构ZX01B","右侧驾驶转向操纵装置","4*2,6*4液压动力转向系统","4*2,6*2液压动力转向系统","8*4液压动力转向系统","4*2,6*4转向拉杆","8*4转向拉杆"),
new Array("车架","牵引车4*2","载货车4*2","自卸车6*4","牵引车6*4","载货车6*4","自卸车8*4","载货8*4"),
new Array("其他")
);
</SCRIPT>
<SCRIPT language=JavaScript>
function changezcmc(){
index = Form1.zc.options.selectedIndex-1;
Form1.zcmc.length = zcmc[index].length;
for(var i = 0;i<zcmc[index].length;i++)
{
var text = zcmc[index][i].split("-");
Form1.zcmc.options[i].text = text[0];
Form1.zcmc.options[i].value =text[1];
}
}
</SCRIPT>
。。。。。。
。。。。。。
<select name="zc" onChange=changezcmc()>
<option selected>选择总成类别</option>
<option value=驾驶室及附件>驾驶室及附件</option>
<option value=前轴>前轴</option>
<option value=后驱动桥>后驱动桥</option>
<option value=发动机及附件>发动机及附件</option>
<option value=离合器及操纵>离合器及操纵</option>
<option value=变速箱及操纵>变速箱及操纵</option>
<option value=传动轴>传动轴</option>
<option value=前悬挂系统>前悬挂系统</option>
<option value=后悬挂系统>后悬挂系统</option>
<option value=底盘电器>底盘电器</option>
<option value=制动元器件>制动元器件</option>
<option value=转向系统>转向系统</option>
<option value=车架>车架</option>
<option value=其他>其他</option>
</select>

所属总成名称:
<select name=zcmc>
<option selected="selected">总成名称</option>
</select>

提交处理以后,zcmc字段总是存不进数据库里,库中只显示undefined。
哪里错了呀,高手给指点一下!高分求助,在线等!
下边是保存数据的代码
<!--#include file="conn.asp"-->
<%
set rs=server.CreateObject ("adodb.recordset")
sql="select * from cpinfo"
rs.open sql,conn,1,3
cpname=request.form("cpname")
tuhao=request.form("tuhao")
texing=request.form("texing")
danjia=request.form("danjia")
changshang=request.form("changshang")
beizhu=request.form("beizhu")
cx=request.form("cx")
zc=request.form("zc")
zcmc=request.form("zcmc")
rs.addnew
rs("cpname")=cpname
rs("tuhao")=tuhao
rs("texing")=texing
rs("danjia")=danjia
rs("changshang")=changshang
rs("beizhu")=beizhu
rs("cx")=cx
rs("zc")=zc
rs("zcmc")=zcmc
rs("date")=date

rs.update
rs.close
set rs=noting
conn.close
set conn=nothing
response.write"<SCRIPT language=JavaScript>alert('产品添加成功!');"
response.write"javascript:history.go(-1)</SCRIPT>"
%>

你存数据库的时候,用什么方法获取的zcmc字段的数据?可能是获取的参数错误导致的。

你的生成选项函数中有错误,下面是修改之后的函数,你参考下:
修改的地方为:
Form1.zcmc.options[i].text = text[0];
Form1.zcmc.options[i].value =text[1];
我帮你修改为:
Form1.zcmc.options[i].text = text[0];
Form1.zcmc.options[i].value =text[0];
不然选项中显示的选项与value的值不会对应,所以错误。

<SCRIPT language=JavaScript>
function changezcmc(){
index = Form1.zc.options.selectedIndex-1;
Form1.zcmc.length = zcmc[index].length;
for(var i = 0;i<zcmc[index].length;i++)
{
var text = zcmc[index][i].split("-");
Form1.zcmc.options[i].text = text[0];
Form1.zcmc.options[i].value =text[0];
}
}
</SCRIPT>

zcmc=request.form("zcmc")

先测试一下zcmc值是没有提交!

请问你是用什么方式提交数据的?是POST 还是GET?
JavaScript 代码方面除了要增加一个 Form1 表单,其它没有任何错!