错误如上
代码如下:
if request.form("id"&cstr(rows))<>"" then
rs.close
RS.Open "select top 1 * from [news_jiage] where xuhao="&request.form("id"&cstr(rows)) , cn, 3 , 3
if not rs.eof then
rs("产品名")=trim(request.form("TEXT_COL0")(rows))
rs("报价0")=request.form("TEXT_COL3")(rows)
rs("hangqingid")=hqid
rs("报价日期")=request.form("TEXT_COL6")(rows)
rs("单位")=request.form("TEXT_COL4")(rows)
tibaoren1=left(trim(rs("adminid")) &","& cstr(tibaoren),10)
rs("adminid")=tibaoren1
'response.write "<br>"&tibaoren1&"<br>"
rs.update
end if
else
response.write ("select top 1 报价0 from news_jiage where hangqingid="&hqid &" and 报价日期='"&request.form("TEXT_COL6")(rows)&"'")
set rsjgcf=cn.execute ("select top 1 报价0 from news_jiage where hangqingid="&hqid &" and 报价日期='"&request.form("TEXT_COL6")(rows)&"'")
if rsjgcf.eof then
rs.addnew
rs("报价0")=request.form("TEXT_COL3")(rows) <------------(
错误提示点)
rs("产品名")=trim(request.form("TEXT_COL0")(rows))
rs("hangqingid")=hqid
rs("报价日期")=request.form("TEXT_COL6")(rows)
rs("adminid")=tibaoren
rs("单位")=request.form("TEXT_COL4")(rows)
rs.update
else
response.write "<font color=red>价格在数据库中已存在 "&rsjgcf("报价0")&"</font><br>"
end if
rsjgcf.close
set rsjgcf=nothing
end if