Updating lakeparam and chronbyid.

SimonGoring · SimonGoring · commit 8d8d2e1408ef · 2020-09-17T12:28:49.000-07:00
diff --git a/function/da/chronologybyid.sql b/function/da/chronologybyid.sql
@@ -43,8 +43,8 @@ AS $function$
         aty.agetype,
         chr.ageboundolder,
         chr.ageboundyounger,
-		chr.agemodel,
-    chr.notes,
-	chr.chronologyid,
-    chr.dateprepared
+		    chr.agemodel,
+        chr.notes,
+	      chr.chronologyid,
+        chr.dateprepared
 $function$
diff --git a/function/ts/updatelakeparam.sql b/function/ts/updatelakeparam.sql
@@ -16,7 +16,7 @@ AS $function$
       FROM ndb.lakeparameters AS lp
       WHERE lp.siteid = _siteid
       GROUP BY lp.lakeparameterid
-      HAVING lp.lakeparameterid = lakeparameterid);
+      HAVING lp.lakeparameterid = _lakeparameterid);
 
     /* If nparam is not null, then the LakeParameter is already in Neotoma */
 
