var xmlHttp
var results
var newvalues
var ID_Keeper

function SaveForm(Formname) {
	
	Submit_Type = document.getElementById("VAR_Submit").value
	Submit_File = document.getElementById("VAR_SubmitFile").value
	
	switch(Submit_Type) {
	case '1': //BACKGROUND POST ACTION
	 	xmlHttp=GetXmlHttpObject();
		if (xmlHttp==null)
		  {
		  RaiseError(0);
		  return;
		} 
		results = "SV_Test";
		
		var url=Submit_File;
		//url=url+"?values="+values;
		var xmlMessage = CreatePostData(Formname);
		
		xmlHttp.open("POST", url, true)
		xmlHttp.onreadystatechange=stateChanged;
		xmlHttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
		xmlHttp.setRequestHeader("Content-length", xmlMessage.length);
		xmlHttp.setRequestHeader("Connection", "close");
		xmlHttp.send(xmlMessage);
		
	  break
	case '2': //STANDARD POST ACTION
		var theForm;
		theForm = document.forms[Formname].name;
			
		document.forms[theForm].action = Submit_File;
		document.forms[theForm].submit();
	  break
	default:
	}
}

function CreatePostData(theFormName) {
    theForm = document.forms[theFormName];
    var qs = ''
    for (e=0;e<theForm.elements.length;e++) {
        if (theForm.elements[e].name!='') {
            var name = theForm.elements[e].name;
            qs+=(qs=='')?'':'&'			
            qs+= name+'='+escape(theForm.elements[e].value);
        }
    }
    qs+="\n";
    return qs
} 

function PassVarsToDatabase(file,table,columns, values, result, newvalue)
	{ 
	xmlHttp=GetXmlHttpObject();
	if (xmlHttp==null)
	  {
	  RaiseError(0);
	  return;
	} 
	var url=file;
	url=url+"?values="+values;
	url=url+"&table="+table;
	url=url+"&columns="+columns;
	
	results = result
	newvalues = newvalue

	//xmlHttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
	xmlHttp.onreadystatechange=stateChanged;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function stateChanged()
	{ 
	switch (xmlHttp.readyState){
		case 4:
			if (xmlHttp.status == 200) {
				Tempvar = results.substring(0,2)
				RealFL = results.substring(3,results.length)
				
				switch (Tempvar){
					case "LB":
						var response_asp
						response_asp = xmlHttp.responseText
						var is_there_any_error = response_asp.indexOf('error');
										
						if (is_there_any_error == - 1) {
							addOption(document.getElementById(RealFL),document.getElementById(newvalues).value,document.getElementById(newvalues),xmlHttp.responseText)
	
						} else {
							alert(xmlHttp.responseText);
						}
						
						break;
					case "SV":
						alert(xmlHttp.responseText);
						break;
					case "MI":
						//document.getElementById("BTN_VarID").value = xmlHttp.responseText
						//alert(document.getElementById("BTN_VarID").value);
						break;
					default : //ERROR;
				}
				break;
			} else {
				RaiseError(0);
			}
		default : //ERROR;
	}
}

function GetXmlHttpObject()
	{
	var xmlHttp=null;
	try
	  {
	  // Firefox, Opera 8.0+, Safari
	  xmlHttp=new XMLHttpRequest();
	  }
	catch (e)
	  {
	  // Internet Explorer
	  try
		{
		xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
		}
	  catch (e)
		{
		xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
		}
	  }
	return xmlHttp;
}

function Add(Q_File, Q_Table, Q_Columns, Q_Values, Q_Results) {
	
	temp1 = document.getElementById(Q_Columns).value.split("|")
	ColumnName = temp1[temp1.length - 1]
	
	ExecuteQuery(Q_File, Q_Table, Q_Columns, Q_Values, Q_Results)
}

function ExecuteQuery(Q_File, Q_Table, Q_Columns, Q_Values, Q_Results) {
	values = document.getElementById(Q_Values).value
	temp2 = ""
	temp1 = values.split("|")
	Newvalue = document.getElementById(temp1[0]).name;
	
	for (var i=0; i < temp1.length; i++) 
	{	
		temp2 = temp2 + "|" + document.getElementById(temp1[i]).value;
	}
	
	
	Values = temp2.substring(1,temp2.length)
	Columns = document.getElementById(Q_Columns).value	
	Result = document.getElementById(Q_Results).value
	File = document.getElementById(Q_File).value
	Table = document.getElementById(Q_Table).value
	
	Tempvar = Result.substring(0,2)
	RealFL = Result.substring(3,Result.length)
		
	abcce = CheckIfExists(document.getElementById(RealFL),document.getElementById(Newvalue).value);
		
	if (abcce == false) { 
		
		PassVarsToDatabase(File,Table,Columns,Values,Result,Newvalue);
	} else {
		if (abcce == true) { 
			RaiseError(1);
		}
	}
}