Index: trunk/WEB-INF/src/com/showcase/sql/FinalizeShowcaseDAOImpl.java =================================================================== diff -u -r223 -r246 --- trunk/WEB-INF/src/com/showcase/sql/FinalizeShowcaseDAOImpl.java (.../FinalizeShowcaseDAOImpl.java) (revision 223) +++ trunk/WEB-INF/src/com/showcase/sql/FinalizeShowcaseDAOImpl.java (.../FinalizeShowcaseDAOImpl.java) (revision 246) @@ -47,7 +47,7 @@ con = getDBConnection(); buff = new StringBuffer("SELECT DEALER_ID FROM ATTENDEES WHERE EVENT_ID="); buff.append(event_id); - buff.append(" AND CHECKED_IN='Y'"); + buff.append(" AND CHECKED_IN='Y' AND checked_in_2nd_day = 'Y'"); pstmt = con.prepareStatement(buff.toString()); rs = pstmt.executeQuery(); String dealer = null;