＋设为首页 ＋添加到收藏夹
这是我的搜索页面，问题出在把经复选框选择的记录
插入到另外一个表时失败
<html>
<head>
<title>配件信息</title>
<script language=javascript>
function CheckAll(form1) {
for (var i=0;i<form1.elements.length;i++) {
var e = form1.elements[i];
if (e.name != chkall) e.checked = form1.chkall.checked;
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<!--#include file="conn.asp"-->
<body bgcolor="#ffffff" text="#000000">
<form method="POST" name="form" action="temp.asp">
<%peijian=trim(request("peijian"))%>
<%
if request("peijian")="null" then
response.write"请输入关键字！"
else
B="select * from qipei where peijian like %"&peijian&"%"
Set RS=conn.execute(B)
if RS.eof then
response.write"对不起，没有您要找的零件！"
end if
end if
%>
<table border="1" width="600" height="50" cellpadding="0" cellspacing="0" bordercolor="#003366" align="center">
<tr bgcolor="#CBEFDC">
<td align="right" height="50" bordercolor="#4F4F4F" colspan="6">
<p align="center"><b><font face="楷体_GB2312" color="#000000" size="5">汽车－配件信息</font></b>
</td>
</table>
<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600" align="center">
<td align="center" colspan="7" height="15">
<tr>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">序号</font></td>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">车型</font></td>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">配件</font></td>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">价格1</font></td>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">价格2</font></td>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">价格3</font></td>
<td align="center" bgcolor="#CBEFDC" height="15"><font size="2">操作</font></td>
</tr>
<tr>
<% On Error Resume Next
RS.MoveFirst
do while not RS.EOF
%>
<td align="center"><font size="2"><%=rs("id")%></font></td>
<td align="center"><font size="2"><%=rs("chexin")%></font></td>
<td align="center"><font size="2"><%=rs("peijian")%></font></td>
<td align="center"><font size="2"><%=rs("price1")%></font></td>
<td align="center"><font size="2"><%=rs("price2")%></font></td>
<td align="center"><font size="2"><%=rs("price3")%></font></td>
<td align="center"><font size="2"><input type="checkbox" name="cc" value="<%="id"%>"></font></td>
</tr>
<%RS.MoveNext
loop
RS.cloce
%>
<td colspan="7" align="center">
<input type="checkbox" name="chkall" value="on" onClick="CheckAll(this.form)">
全选/取消
<input name="Submit" type="submit" class="button" id="Submit" value="执行" onClick="{if(confirm(您确定执行的操作吗?)){return true;}return false;}">
</tr>
</table>
</form>
</body>
</html>
这是复选框插记录的后台页面<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title></title>
<!--#include file="conn.asp"-->
</head>
<body>
<%
cc=request("cc")
sql="insert into temp (id,chexin,peijian,price1,price2,price3) select id,chexin,peijian,price1,price2,price3 from peijian where id in ("&cc&")"
conn.execute(sql)
%>
</body>
</html>
这是提示的错误类型：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
/temp.asp, 第 14 行
浏览器类型：
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
页：
POST 107 bytes to /temp.asp
POST 数据:
cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&cc=id&chkall=on&Submit=%D6%B4%D0%D0
谢谢大家帮忙找一找错～～
<input type="checkbox" name="cc" value="<%="id"%>">错误，
应该是<input type="checkbox" name="cc" value="<%=id%>">
sql语句也不对，看不懂你象实现什么功能:(
另外你的ID是自增长的吗？如果是的话为什么insert的时候还要指定id呢？
