<%@LANGUAGE="JAVASCRIPT"%>
<%
var Greek = Server.CreateObject("ADODB.Recordset");
Greek.ActiveConnection = MM_greek2_STRING;
Greek.Source = "SELECT * FROM allgreek.products";
Greek.CursorType = 0;
Greek.CursorLocation = 2;
Greek.LockType = 1;
Greek.Open();
var Greek_numRows = 0;
%>
<%
// *** Add to cart: Find correct record and call cart method to add item
var UC_rs=Greek;
var UC_uniqueCol="Ecode";
var UC_AddLink;
if (Request.QueryString == "") {
UC_AddLink = Request.ServerVariables("URL") + "?UC_AddId=";
} else {
UC_AddLink = Request.ServerVariables("URL") + "?" + Request.QueryString + "&UC_AddId=";
}
var UC_AddId=String(Request("UC_AddId"));
// Add item to cart using recordset contents.
if (UC_AddId != "undefined") {
var UC_redirectPage = "/jewellery/cart.asp";
if (UC_rs != null) {
// Position recordset to correct location
if (UC_rs.Fields.Item(UC_uniqueCol).Value != UC_AddId) {
// reset the cursor to the beginning
if (UC_rs.CursorType > 0) {
if (!UC_rs.BOF) UC_rs.MoveFirst();
} else {
UC_rs.Close();
UC_rs.Open();
}
for (var UC_offset=0; !UC_rs.EOF; UC_offset++) {
if (UC_rs.Fields.Item(UC_uniqueCol).Value == UC_AddId) break;
UC_rs.MoveNext();
}
}
}
var UC_BindingTypes=["RS","LITERAL","RS","RS","NONE"];
var UC_BindingValues=["Ecode","1","item","price",""];
UCCart1.AddItem(UC_rs,UC_BindingTypes,UC_BindingValues,"increment");
// always redirect to remove the "UC_AddId" query param.
if (UC_redirectPage == "") UC_redirectPage = Request.ServerVariables("URL");
if (String(UC_redirectPage).indexOf("?") == -1 && Request.QueryString != "") {
var newQS = "?";
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
if (String(items.item()) != "UC_AddId") {
if (newQS.length > 1) newQS += "&";
newQS += items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}
if (newQS.length > 1) UC_redirectPage += newQS;
}
Response.Redirect(UC_redirectPage);
}
%>
Greek Jewellery - online shop selling quality Jewellery from Greece
<%
Greek.Close();
%>
<%
Greek.ActiveConnection.Close();
Greek = null;
%>