This is a problem with code order.
The add to cart code is at lines 13 - 36:
<%
// WA eCart AddToCart
if (String(WA_DFP_UploadObj.Form("WA_eCart1_1_ATC")) != "undefined" || String(WA_DFP_UploadObj.Form("WA_eCart1_1_ATC.x")) != "undefined") {
var ATC_itemID = String(WA_DFP_UploadObj.Form("WA_eCart1_1_ID_Add"));
var ATC_AddIfIn = 0;
var ATC_RedirectAfter = "cart2.asp";
var ATC_RedirectIfIn = "";
var ATC_itemName = "" + String((Recordset1.Fields.Item("Product").Value)) + "";// column binding
var ATC_itemDescription = "" + String((Recordset1.Fields.Item("Description").Value)) + "";// column binding
var ATC_itemWeight = parseFloat("0");// column binding
var ATC_itemQuantity = "" + String(WA_DFP_UploadObj.Form("WA_eCart1_1_Quantity_Add")) + "";// column binding
var ATC_itemPrice = parseFloat("" + String((Recordset1.Fields.Item("Price").Value)) + "");// column binding
var ATC_itemImage = "" + String(WA_DFP_UploadObj.Form("UploadImage")) + "";// column binding
var ATC_itemSize = "";// column binding
ATC_itemQuantity = parseFloat(ATC_itemQuantity);
if (!isNaN(ATC_itemQuantity) && ATC_itemQuantity != 0) {
WA_eCart1.AddToCart(ATC_AddIfIn, ATC_RedirectIfIn, ATC_itemID, ATC_itemName, ATC_itemDescription, ATC_itemWeight, ATC_itemQuantity, ATC_itemPrice, ATC_itemImage, ATC_itemSize);
if (ATC_RedirectAfter != "" && WA_eCart1_redirStr == "") {
WA_eCart1_redirStr = ATC_RedirectAfter;
}
Session("WAEC_ContinueRedirect") = String(Request.ServerVariables("Script_Name")) + "?" + String(Request.QueryString());
}
}
%>
the recordset code is after that at lines 37 - 53:
<%
var Recordset1__MMColParam = "70";
if (String(WA_DFP_UploadObj.Form("MM_EmptyValue")) != "undefined" &&
String(WA_DFP_UploadObj.Form("MM_EmptyValue")) != "") {
Recordset1__MMColParam = String(WA_DFP_UploadObj.Form("MM_EmptyValue"));
}
%>
<%
var Recordset1_cmd = Server.CreateObject ("ADODB.Command");
Recordset1_cmd.ActiveConnection = MM_GIFTS_DB_STRING;
Recordset1_cmd.CommandText = "SELECT * FROM Product1 WHERE ID = ?";
Recordset1_cmd.Prepared = true;
Recordset1_cmd.Parameters.Append(Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam)); // adDouble
var Recordset1 = Recordset1_cmd.Execute();
var Recordset1_numRows = 0;
%>
you need to rearrange that so the recordset code is before the add to cart code.