@@ -79,9+73,9 @@ 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");