页面提示数据已经提交成功,但数据库就是没有记录,请问是什么问题?
<% if request("action")="add" then
if numb<0 then
response.Write("<script>alert('no enough store');selectitem();</script>")
else
set itemn=server.CreateObject("adodb.recordset")
set itemn=nothing
set rs6=server.CreateObject("adodb.recordset")
rs6.open "select * from customer",conn,3,3
rs6.addnew
rs6("customerno")=trim(request("customerno"))
rs6("customername")=trim(request("Customername"))
rs6("address")=trim(request("Address"))
rs6("tel")=trim(request("tel"))
rs6("ndate")=trim(request("date"))
rs6("purchasedate")=trim(request("Purchasedate"))
rs6("purchaseloaction")=trim(request("Purchaseloaction"))
rs6("invoiceno")=trim(request("invoiceno"))
rs6("productid")=trim(request("product"))
rs6("itemid")=titem
rs6("cnum")=cint(trim(request("num")))
rs6("reasonid")=trim(request("reason"))
rs6("Solutionid")=cint(trim(request("Solution")))
rs6("shipdate")=trim(request("shipdate"))
rs6("issend")=0
rs6.update
rs6.close
set rs6=nothing
response.Write("<script>alert('succeed');location.href='addcustomer.asp';</script>")
end if
end if
%>
谢谢!