Skip to content
Snippets Groups Projects

[UC 41] PR review changes

Merged elengik2 requested to merge uc41 into master
1 file
+ 1
1
Compare changes
  • Side-by-side
  • Inline
@@ -342,7 +342,7 @@ public class ApptDAO {
@@ -342,7 +342,7 @@ public class ApptDAO {
conn = factory.getConnection();
conn = factory.getConnection();
pstring = conn.prepareStatement(
pstring = conn.prepareStatement(
"SELECT * FROM appointment WHERE " + /*" sched_date.after(?)=TRUE AND sched_date.before(?)=TRUE");*/
"SELECT * FROM appointment WHERE " + // select appointments where
"DATE(sched_date)<=DATE_ADD(CURRENT_DATE, INTERVAL ? DAY) AND " + //sched_date day is before or at (numDays) days from now
"DATE(sched_date)<=DATE_ADD(CURRENT_DATE, INTERVAL ? DAY) AND " + //sched_date day is before or at (numDays) days from now
"sched_date>=CURRENT_DATE"); // sched_date is after today
"sched_date>=CURRENT_DATE"); // sched_date is after today
Loading