把提交页面代码和服务器接受代码分开处理,变成两个ASP文件
这一部分保存为:save.asp
<%
if trim(request.Form("changesForm")) = "1" then
travelname = trim(request.Form("travelname"))
traveltime = trim(request.Form("traveltime"))
traveltime = "to_date('"&traveltime&"','yyyy-mm-dd hh24:mi:ss')"
travelsize = trim(request.Form("travelsize"))
remark = trim(request.Form("remark"))
price = trim(request.Form("price"))
sqlstr = "INSERT INTO CQSSS.TRAVEL_FEEDBACK (ID,PHONENUMBER,TRAVELNAME,TRAVELTIME,TRAVELSIZE,REMARK,PRICE) VALUES (CQSSS.SEC_TRAVEL_FEEDBACK.Nextval,"&phonenumber&",'"&travelname&"',"&traveltime&","&travelsize&",'"&remark&"',"&price&")"
set db = new dbutil
db.conn "cqsss"
db.execUpdate sqlstr
response.write ""
end if
%>
-------------------------------------------------------------
上面的提交成功力加一个链接返回这里,以下的表单里action="save.asp"
以下的保存为:show.asp