Displaying differences for changeset
 
display as  

src/java/m/wqm/pestpractscores/V1_0.java

@@ -75,10 +75,9 @@
              int pdrift_practice_score=0;
              String query;
              query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Leaching'" ;  
-             if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){
-                System.out.println("String is not null"); 
-                query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
-             System.out.println(ip.plan_pract_variant);
+             if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){ 
+                query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
+             //System.out.println(ip.plan_pract_variant);
              //System.out.println(ip.AoAId);
              ResultSet results = statement.executeQuery(query);
 
@@ -89,8 +88,8 @@
                 }
              query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Solution Runoff'" ;
              if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){
-                query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
-             System.out.println(query);
+                query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
+             //System.out.println(query);
                 results = statement.executeQuery(query);
              
                 while (results.next())
@@ -100,8 +99,8 @@
                 }
              query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Adsorbed Runoff'" ;
              if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){
-                query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
-             System.out.println(query);
+                query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
+             //System.out.println(query);
                 results = statement.executeQuery(query);
 
                 while (results.next())
@@ -111,8 +110,8 @@
                 }
             query="SELECT ipm_practice_score FROM wqm_ipm_practice_scores WHERE practice_id='"+ip.plan_ipm_practice+"' AND wqm_concern='Pesticide Drift'" ;
             if (ip.plan_pract_variant!=null && !ip.plan_pract_variant.isEmpty()){
-                query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
-            System.out.println(query);
+                query=query.concat(" AND practice_variant='"+ip.plan_pract_variant+"'");}
+            //System.out.println(query);
                 results = statement.executeQuery(query);
 
                 while (results.next())