Thanks for your guys' help...
So if anywhere in my page I have a response.redirect the server will send the status of 300. In my script I handle it like this...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/connstore.asp" -->
<%
Dim Item_ID 'variable passed back by PayPal
'read post from PayPal system and add 'cmd'
str = Request.Form
Item_ID = Request.Form("Item_Number1")
Payment_status = Request.Form("payment_status")
' Post back to PayPal system to validate
str = str & "&cmd=_notify-validate"
set objHttp = Server.CreateObject("Msxml2.ServerXMLHTTP.4.0")
objHttp.open "POST", "https://www.paypal.com/cgi-bin/webscr", false
objHttp.Send str
' Check notification validation
If (Item_ID <> "") then
if (objHttp.status <> 200 ) then
response.Redirect("pagenotavail.htm")
'check to see if it was a purchase made through
www.rrrtifax.comelseif (Payment_status = "PENDING") then
set Cm = Server.CreateObject("ADODB.Command")
Cm.ActiveConnection = MM_connStore_STRING
Cm.CommandText = "UPDATE tblProducts SET SoldFlag = true WHERE Item_ID = '" & Item_ID & "'"
Cm.CommandType = 1
Cm.Execute
response.Redirect("thankyou.htm")
elseif (Payment_status = "FAILED") then
response.Redirect("statusfailed.htm")
elseIf (objHttp.responseText <> "VERIFIED" and Payment_status = "COMPLETED") then
'update the item to sold after a confirmation from paypal
set Cm = Server.CreateObject("ADODB.Command")
Cm.ActiveConnection = MM_connStore_STRING
Cm.CommandText = "UPDATE tblProducts SET SoldFlag = true WHERE Item_ID = '" & Item_ID & "'"
Cm.CommandType = 1
Cm.Execute
'We end the insert into our database table
End If
End If
response.Redirect("thankyou.htm")%>
Would these redirects be my problem?
Thanks again,
Nathan