
function GenerateText(schoolyear)
{
	Response.ContentType="text/plain";
try {
//	var schoolyear = Request("schoolyear");
	var sql = "SELECT district, districtname, campus, campusname, region, students_free_reduced, " 
		+ " students,students_free_reduced_percent,schoolyear FROM nslp WHERE schoolyear = " + schoolyear
		+ " order by region, district, campus";
		
	NSLPCon = Server.CreateObject("ADODB.CONNECTION");
	NSLPCon.Open("DSN=erate","slduser","password");
	NSLPCmd = Server.CreateObject("ADODB.Command");
	NSLPCmd.ActiveConnection = NSLPCon;                             
	NSLPRecSet = Server.CreateObject("ADODB.Recordset");
	NSLPRecSet.Source = NSLPCmd;
	NSLPCmd.CommandText = sql;
	NSLPRecSet.Open();
	
	if (NSLPRecSet.EOF || NSLPRecSet.BOF)
		Response.End();
		
	for(h = 0; h<=NSLPRecSet.Fields.Count -1;h++)
	{
		Response.Write(NSLPRecSet.Fields(h).Name + ",");
	}
	Response.Write("<br />");
	while ( !NSLPRecSet.EOF && !NSLPRecSet.BOF )
	{
		for(i = 0; i <= NSLPRecSet.Fields.Count -1; i++)
		{
			
			if ( i == 5 || i == 6 || i == 7 )
			{
				if ( NSLPRecSet.Fields(5) <= 0 || NSLPRecSet.Fields(6) < 0) {
					Response.Write("**,");
				}
				else {
					if ( NSLPRecSet.Fields(5) > 0 && NSLPRecSet.Fields(5) <= 5 )
						Response.Write("**,");			
					else
						Response.Write(NSLPRecSet.Fields(i) + ",");
				}
			}
			else 
			{
				Response.Write(NSLPRecSet.Fields(i) + ",");
			}
		}
		Response.Write("<br />");
		NSLPRecSet.MoveNext();
	}
	Response.End();
	NSLPRecSet.Close();
	//NSLPCmd.Close();
	NSLPCon.Close();	
}
catch (err)
{
//	if (NSLPRecSet.Status == 1) {
//		NSLPRecSet.Close();
//	}
//	
//	if (NSLPConn.State == 1) {
//		NSLPConn.Close();
//	}
//	Response.Write(NSLPRecSet.Status + "\r");	
	Response.ContentType = "text/html";
	Response.Write("<p><strong>There was a problem generating the file.</strong><br /> If you continue to recieve this error, please inform the Texas E-Rate Coordinator by phone: 254-297-1123 or email: erate@esc12.net</p>");
}
}
