var rs;
		var xmldoc; 
		var xmlstream; 
		var xmlcon;
		
		String.prototype.trim = function() { return this.replace(/^\s+|\s+$/, ''); };
		
		function getPRD() {
		rs = new ActiveXObject("ADODB.Recordset");		
		xmldoc = new ActiveXObject("Msxml2.DOMDocument");
   		var xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
   		
		var w = document.getElementById('ddlState').selectedIndex;		
		var state = document.getElementById('ddlState').value;		
		document.getElementById('ddlPackage').options.length = 0;
		document.getElementById('ddlPackage').options[0]=new Option('-Select One-', '0'); 				
		if (state == -1) return false;
		state = "'" + state + "'";	
		
   		xmlhttp.Open("Get","Sender.asp?getRecordset=PROD&getState="+state,false);   		
   		xmlhttp.send();                                                                        		
   		xmldoc.loadXML(xmlhttp.responseText);    		
   		rs.Open(xmldoc);                         		
   		loadPROD();
		}
		function loadPROD() {		
			if (rs.PAGECOUNT > 0)
			{   				
				while (!(rs.EOF))
				{
					var optn = document.createElement("OPTION");
					optn.text = rs.Fields(1).Value + ' - ' +  rs.Fields(2).Value
					optn.value = rs.Fields(0).Value
					document.getElementById('ddlPackage').options.add(optn);				
					rs.Movenext;
				}
			}
		}
		
		function getSponsor() {		
		document.getElementById('lblSponsorName').innerText = "";
		rs = new ActiveXObject("ADODB.Recordset");
		xmldoc = new ActiveXObject("Msxml2.DOMDocument");
   		var xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");   		  		
		var sname = document.getElementById('txtSponsorName').value;		
		sname = sname.trim();
		if (sname == "" || sname.length <1)                                 
		{
			document.getElementById('txtSponsorName').value="";				
			return false;
		} 		
		sname = "'" + sname + "'"
		
   		xmlhttp.Open("Get","Sender.asp?getRecordset=SPONSOR&getSponsor="+sname,false);
   		 		
   		xmlhttp.send();       //alert('Yes');                                                                   		
   		xmldoc.loadXML(xmlhttp.responseText);    		
   		rs.Open(xmldoc);    		
   		loadSPONSOR();
		}
		function loadSPONSOR() {								
			if (rs.PAGECOUNT > 0)
			{   			
				document.getElementById('lblSponsorName').innerText = "";
				var sptrack = document.getElementById('txtSponsorTrackId').value;
				if (sptrack.length > 0) getSponsorTrackID();
			}			
			else
			{
				var sname = document.getElementById('txtSponsorName').value;
				document.getElementById('txtSponsorName').value="";
				document.getElementById('lblSponsorName').innerText =  "Sorry! " + sname + " - Sponsor name not found!";
				document.getElementById('txtSponsorName').focus();
			}
		}
		
		function getTrackID() {		
		document.getElementById('lblSponsorName').innerText = "";
		rs = new ActiveXObject("ADODB.Recordset");
		xmldoc = new ActiveXObject("Msxml2.DOMDocument");
   		var xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
   		
   		
		var sname = document.getElementById('txtSponsorTrackId').value;				
		if (sname == "" || sname.length <1)                                 
		{
			document.getElementById('txtSponsorTrackId').value="";				
			return false;
		}
		sname = "'" + sname + "'"
		
   		xmlhttp.Open("Get","Sender.asp?getRecordset=TrackID&getTrackID="+sname,false);   		
   		xmlhttp.send();                                                                        		
   		xmldoc.loadXML(xmlhttp.responseText);    		
   		rs.Open(xmldoc);    		
   		loadTrackID();   		
		}
		function loadTrackID() {								
			if (rs.PAGECOUNT > 0)
			{   			
				document.getElementById('lblSponsorName').innerText = "";
				var spname = document.getElementById('txtSponsorName').value;
				if (spname.length > 0) getSponsorTrackID();
			}			
			else
			{
				var sname = document.getElementById('txtSponsorTrackId').value;
				document.getElementById('txtSponsorTrackId').value="";
				document.getElementById('lblSponsorName').innerText =  " Sorry! " + sname + " - Sponsor TrackID not found!";
				document.getElementById('txtSponsorTrackId').focus();
			}
		}
		
		function getSponsorTrackID() {
		document.getElementById('lblSponsorName').innerText = "";
		rs = new ActiveXObject("ADODB.Recordset");
		xmldoc = new ActiveXObject("Msxml2.DOMDocument");
   		var xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
   	
		var sname = document.getElementById('txtSponsorName').value;		
		var strack = document.getElementById('txtSponsorTrackId').value;		
		strack = "'" + strack + "'"	
		sname = "'" + sname + "'"	
			
   		xmlhttp.Open("Get","Sender.asp?getRecordset=SponsorTrackID&getTrackID="+strack+"&getSponsor="+sname,false);   		
   		xmlhttp.send();                                                                        		
   		xmldoc.loadXML(xmlhttp.responseText);    		
   		rs.Open(xmldoc);    		
   		loadError();
		}
		function loadError() {								
			if (rs.PAGECOUNT > 0)
			{   			
				document.getElementById('lblSponsorName').innerText = "";
			}			
			else
			{
				document.getElementById('txtSponsorTrackId').value="";
				document.getElementById('txtSponsorName').value="";
				document.getElementById('lblSponsorName').innerText =  " Sorry! Sponsor User Name and TrackID mismatch!";
				document.getElementById('txtSponsorTrackId').focus();
			}
		}
		
		function callPackChange()
		{
			document.getElementById('lblPackID').value=document.getElementById('ddlPackage').value;			
			var w = document.getElementById('ddlPackage').selectedIndex;			
			document.getElementById('lblPack').value= document.getElementById('ddlPackage').options[w].text;
		}