rs.open sql conn,1,3 错误 为什么
<%@LANGUAGE="VBSCRIPT"%><!--#include file="../Connections/CONN.asp" -->
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sqL="select cpel_time,cpel_biaoti,cpel_djs,cpel_nr,cpel_ss_cpyl,img FROM dbo.CPEL"
rs.open sql conn,1,3
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
红色字段 sql数据库,
cpel_biaoti=Request.Form("cpel_biaoti")
img=Request.Form("img")
cpel_nr=Request.Form("cpel_nr")
cpel_djs=Request.Form("cpel_djs")
cpel_ss_cpyl=Request.Form("cpel_ss_cpyl")
if cpel_biaoti="" then
response.Write("<script language=javascript>alert('产品标题不能为空!');history.go(-1)</script>")
response.end
end if
if img="" then
response.Write("<script language=javascript>alert('示例图片不能为空!');history.go(-1)</script>")
response.end
end if
if cpel_nr="" then
response.Write("<script language=javascript>alert('产品介绍不能为空!');history.go(-1)</script>")
response.end
end if
rs.addnew
rs("cpel_biaoti")=cpel_biaoti
rs("img")=img
rs("cpel_nr")=cpel_nr
rs("cpel_djs")=cpel_djs
rs("cpel_ss_cpyl")=cpel_ss_cpyl
rs("cpel_time")=now()
rs.update
rs.close
set rs = nothing
conn.Close()
Set rs = Nothing
%>
<%
Response.Write "<script>alert('产品增加成功!点击继续添加!');window.location.href='ind.asp';</script>"
%>