form.output(out, getLanguage(req), new HashMap<String, Object>());
}
form.output(out, getLanguage(req), new HashMap<String, Object>());
@@ -79,26+76,27 @@ public class AssurePage extends Page {
return;
}
return;
}
- ResultSet rs = null;
+ GigiResultSet rs = null;
try {
try {
- PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT id, verified FROM users WHERE email=? AND dob=? AND deleted=0");
+ GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `users`.`id`, `verified` FROM `users` INNER JOIN `certOwners` ON `certOwners`.`id`=`users`.`id` WHERE `email`=? AND `dob`=? AND `deleted` IS NULL");