thanks, I should have looked a bit harder
the finish page seems to fail ... some suggestions are:
1]connection string code and use of cdonts are deprecated.
should be using oledb
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Data Source=" & Server.MapPath("/NOPCart ASP v2.1/db/database.mdb")
========================================================
and cdo
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
<%
Dim iMsg
Set iMsg = CreateObject("CDO.Message")
Dim iConf
Set iConf = CreateObject("CDO.Configuration")
Dim Flds
Set Flds = iConf.Fields
With Flds
' assume constants are defined within script file
.Item(cdoSendUsingMethod) = cdoSendUsingPort
.Item(cdoSMTPServer) = "localhost"
.Item(cdoSMTPConnectionTimeout) = 20 ' quick timeout
.Item(cdoURLGetLatestVersion) = True
.Update
End With
With iMsg
Set .Configuration = iConf
.To = ToA
.From = sFrom
.Subject = Subject
.TextBody = Mybody
.Send
End With
Set iConf = nothing
Set iMsg = nothing
SendMail = True
%>
====================================================
2] these many product lines don't seem to match up with checkout page:
for ex.
rsUsers("Product1") = ""&request.form("QUANTITY_1")&" $"&request.form("PRICE_1")&" "&request.form("ID_1")&" - "&request.form("NAME_1")&" "&request.form("ADDTLINFO_1")
no comments in code so can't be sure of why they exist...
====================================================
3] database has address 2 as required -- should be allowed blank
=====================================================
4] database seems to be set up for auction ??