Question

ASP set rst1=conn.Execute这句提示有问题，不知道错在哪？

<%
'创建recordset对象方法1 part,brand,date_code,qty,price from product
set rst=Server.CreateObject("ADODB.recordset")
rst.open "select * from product where part='" & request.form("f_part") & "'",conn,1,1
if rst.recordcount>0 then
'如果存在这个型号，对型号进行提示
response.write "型号：" & request.form("f_part") & "已经存在！"
response.end
else
'如果型号不存在则写入数据

set rst1=conn.Execute("insert into product (part,brand,date_code,qty,price) values ('" & request.form("f_part") & "','" & request.form("f_brand") & "','" & request.form("f_date_code") & "','" & request.form("f_qty") & "','" & request.form("f_price") & "')")

end if
%>

Answer 1

把这句改成

conn.Execute("insert into product (part,brand,date_code,qty,price) values ('" & request.form("f_part") & "','" & request.form("f_brand") & "','" & request.form("f_date_code") & "','" & request.form("f_qty") & "','" & request.form("f_price") & "')")

conn.Execute只返回执行的行数，不返回记录集