acceptorder.asp

javascript source code part2

<!--#include file="ServerSideGlobalDef.inc"-->
<% 

	// Get Order info
	var sCustEmail  = "Thank you for shopping with MusicMad.Com\n\nThe following items\n\n";
	var sOrderDeptEmail = "Send the following items - ";
	var sAddress = "";	
	var iTotal = 0;
	var iOrderId = Request.QueryString;	
	var loConn = Server.CreateObject("ADODB.Connection");
	var loRS;
	
	// Retrive customer details from database
	loConn.Open(sdbConnString);
	loRS = loConn.Execute("CustomerDetails " + iOrderId);
	// create customer address part of e-mail
	sAddress = sAddress.concat(loRS("Title")," ",loRS("FirstName")," ",loRS("LastName"),"\n");
	sAddress = sAddress.concat(loRS("Street"),"\n",loRS("City"),"\n",loRS("Locality"),"\n");
	sAddress = sAddress.concat(loRS("PostCode"),"\n",loRS("Country"),"\n");
	
	sEmail = new String(loRS("Email"));
	
	loRS.Close();
	// Retrive order details - list of all items to be sent
	loRS = loConn.Execute("OrderDetails " + iOrderId);
	
	// create the order detail par of the e-mail
	while (!loRS.Eof)
	{
		sCustEmail = sCustEmail.concat(loRS("Title")," by ", loRS("ArtistName")," Qty ", loRS("Qty"), " @