Provider (0x80020005)错误

[hxsncng]

购物车的功能.一次购买一件商品时能下订单,但不能同时购买两个以下的商品.

报类型不对.

程序如下:
<!--#include file="include/conn.asp" -->
<%
' select case action
' case "add"
set rs1= Server.CreateObject("adodb.recordset")
rs1.open"select * from TP_Product where ProductId in ("&request.Form("product")&")",conn,1,1
do while not rs1.eof

set rs= Server.CreateObject("adodb.recordset")
rs.open "select * from TP_Order ",conn,1,3
rs.addnew


//收货人详细资料
rs("ReciptName")=request.form("sub_to")
rs("ReciptTelephone")=request.form("sub_tel")
rs("ReciptPostcode")=request.form("sub_post")
rs("ReciptAddress")=request.form("sub_adds")
rs("ReciptEmail")=request.form("sub_mail")

//下单人详细资料
rs("PutName")=request.form("sub_from")
rs("PutTelephone")=request.form("sub_fromtel")
rs("PutEmail")=request.form("sub_frommail")
rs("PutAddress")=request.form("sub_fromadds")
rs("Putpostcode")=request.form("sub_frompost")

//其他资料
rs("DeliverId")=request.form("ps_id")
rs("PayId")=request.form("pay_id")
rs("Invoice")=request.form("fapiao")
rs("AddDate")=now()

//订单资料]
shijian=now()
goods=year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)
rs("OrderNo")=goods
rs("UserName")=Request.Cookies("template")("username")

rs("ProductId")=rs1("ProductId")
rs("ProductPrice")=request("productprice") //这里报错
rs("ProducteCount")=request("productcount") //这里报错

rs("AllCost")=request("productallcost") //这里报错

rs("Ordercheck")=1
rs("DeliverCost")=request.form("delivercost")
rs.update

rs.close
set rs=nothing

conn.execute "delete from TP_Order where UserName='"&Request.Cookies("template")("username")&"' and Ordercheck=0"
response.redirect("order.asp?goods="&goods&"")
rs1.movenext
loop
rs1.close
set rs1=nothing
' end select
%>


那几个值都是从数据库中读出来的.

类型是一样的

为什么就是报错误.

另外我想问一下 request("xxx") 和request.form("xxx")有什么具体不同
深入点.谢谢!
急!

[hookee]

request对象包含以下5个集合
QueryString
Form
Cookies
ClientCertificate
ServerVariables
request("xxx")就从这5个集合里找xxx，而request.form("xxx")就从form集合里找。

如果你递交过来的xxx不止一个，那么用request.form("xxx")(n) 访问每个值。

[sishen50]

？？