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

// Performs a GET to our processSQL.aspx web page with the query
function sendRequest()
{
	obj=getXMLHTTPRequest();
	//var docname = document.getElementById("btnA").value;
	if (obj!=null)
	{
	   		var query = document.getElementById("txtQuery").value;
	   		query="";
	   		var rows=1100;
			obj.onreadystatechange = processResponse;
			obj.open("GET","http://dotdeals.com/ProcessSqlCount.aspx?query="+escape(query)+"&rows="+rows,true);
	    }
	return false;
}

// Process the HTTP Response when it is complete
function processResponse()
{
	if (obj.readyState == 4)
	{
		if (obj.status == 200)
		{
			var retval=obj.responseText;
			if (document.getElementById("resultsCount")!=null)
			{
				document.getElementById("resultsCount").innerHTML = retval;
			}
			else
			{
				alert("Error retrieving data!");
			}
		}
	}
}

// Send the query and parameters to the server side script for processing
function generateGrid(catTypeId)
{
	obj=getXMLHTTPRequest();
	var docname = document.getElementById("txtname").value;
	if (obj!=null)
	{
	    var query = document.getElementById("txtQuery").value;
	    query="";
	    var rows=100;
	    var sortExpr = document.getElementById("txtSort").value;
	    var page = document.getElementById("txtPage").value;
		obj.onreadystatechange = processResponse;
		obj.open("GET","http://dotdeals.com/ProcessSqlCount.aspx?query="+escape(query)+"&catId="+docname+"&catTypeId="+catTypeId+"&rows="+rows+"&gridpage="+page+"&expression="+sortExpr,true);
		obj.send(null);
}
	return false;
}

// Called when a column header is clicked
function sortGrid(sortExpr)
{
	document.getElementById("txtSort").value = sortExpr;
	generateGrid();
}

// Called when the grid is paged
function pageGrid(page,type)
{
	document.getElementById("txtPage").value = page;
	generateGrid(type);	
}