anchor.diff:  	float p_amount_price=0;
   	while(rs.next())
   	{
  -		p_id=rs.getInt(1);
  -		p_name=rs.getString(2);
  -		p_amount_price=rs.getFloat(3);
  +		p_id=rs.getInt("id");
  +		p_name=rs.getString(1);
  +		p_amount_price=rs.getInt("amount");
   		item=new Item();
   		item.setId(p_id);
   		item.setName(p_name);
  
positive.code: 		{
  			System.out.println("rows: states - no filters");
  			/** pulls state names, no filters**/
  			SQL_2="select  u.state, sum(s.quantity*s.price) as amount from users u, sales s,  products p "+
  						  "where s.uid=u.id and s.pid=p.id "+ 
  						  "group by u.state "+ 
  						  "order by u.state asc "+
  						  "limit 20" +"offset "+r_offset+";"; 
  			SQL_21="select  u.state, sum(s.quantity*s.price) as amount from users u, sales s,  products p "+
  					  "where s.uid=u.id and s.pid=p.id "+ 
  					  "group by u.state "+ 
  					  "order by u.state asc "+
  					  "limit 1" +"offset "+next_r_offset+";";
  		}
  		else
  		{
  			System.out.println("rows: states - state filters");
  			/* pulls state names, state filter */
  			SQL_2="select  u.state, sum(s.quantity*s.price) as amount from users u, sales s,  products p "+
  						"where s.uid=u.id and s.pid=p.id AND u.state='"+ state +"'" + 
  						"group by u.state "+ 
  						"order by u.state asc "+
  						"limit 20" +"offset "+r_offset+";"; 
  			SQL_21="select  u.state, sum(s.quantity*s.price) as amount from users u, sales s,  products p "+
  					"where s.uid=u.id and s.pid=p.id AND u.state='"+ state +"'" + 
  					"group by u.state "+ 
  					"order by u.state asc "+
  					"limit 1" +"offset "+next_r_offset+";"; 
  		}
  	}
  	//scope = customers
  
negative.code: 	while(rs_2.next())
  	{
  		s_name=rs_2.getString(1);
  		s_amount_price=rs_2.getInt("amount");
  		item=new Item();
  		item.setName(s_name);
  		item.setAmount_price(s_amount_price);
  		s_list.add(item);
  	}	
  //    out.println("product #:"+p_list.size()+"<br>state #:"+s_list.size()+"<p>");
  	int i=0,j=0;	
  	float amount=0;
  %>
  	<table align="center" width="98%" border="1">
  