addtosave.asp

一个不错的拍卖网站,fdsafdsfdfe

<!--#include file="conn.asp"-->

<!-- #include file="inc/const.asp" -->
<!-- #include file="inc/info.asp" -->
 <%
call header()
dim stitle,snum,scatid,scatsonid,sdays,sImageURL
dim sDesc,sStartBid,sIncrement,sReserve,sykj
dim soldnew,sbaoxiu,sfapiao,syunfei,szhifu,ssonghuo
dim closedate,startdate,owner
stitle=rst("stitle")
snum=rst("snum")
scatid=rst("scatid")
scatsonid=rst("scatsonid")
sdays=rst("sdays")
sImageURL=rst("simageurl")
sdesc=aspeasehtml(rst("sDesc"))
sstartbid=FVal(rst("sstartbid"))
sIncrement=FVal(rst("sIncrement"))
sReserve=rst("sReserve")
sykj=rst("sykj")
soldnew=rst("soldnew")
sbaoxiu=rst("sbaoxiu")
sfapiao=rst("sfapiao")
syunfei=rst("syunfei")
szhifu=rst("szhifu")

ssonghuo=rst("ssonghuo")
closedate=rst("closedate")
startdate=rst("startdate")


owner=rst("owner")

    		
    sql="insert into Auctions (aucEnded,aucEmailsSent,aucItemOwner,aucItemTitle," & _
	 "aucImageURL,aucAvailDate,aucCloseDate,aucStartingBid,aucReservePrice," & _
	 "aucMinimumIncrement,aucCurrentBid,aucDescription,aucbuyprice,catid,catsonid," & _
	 "oldnew,baoxiu,fapiao,yunfei,zhifu,songhuo,aucnum,bidtimes)" & _
	"values('N','N','"&owner&"','"&sTitle&"','"&sImageURL&"','"&startdate&"'," & _
	 "'"&closedate&"','"&sstartbid&"','"&sreserve&"','"&sIncrement&"','"&sstartbid&"'," & _
	 "'"&sdesc&"','"&sykj&"','"&scatid&"','"&scatsonid&"','"&soldnew&"','"&sbaoxiu&"'," & _
	 "'"&sfapiao&"','"&syunfei&"','"&szhifu&"','"&ssonghuo&"','"&snum&"','0')"
set rs=conn.execute(sql)


response.write "你已经发布了拍卖信息 <br>"

call footer()
'rs.close
'set rs=nothing
conn.close
set conn=nothing
%>