private static List<Appointment> findWeeklyByDay(long uid, long day)
			throws SQLException {
		List<Appointment> aAppt = new ArrayList<Appointment>();
		// select * from Appointment where frequency = $WEEKLY
		// and startTime <= $(day + DateUtil.DAY_LENGTH)
		// and lastDay >= $day
		// and freqHelper = $freqHelper
		PreparedStatement statement =
				connect.prepareStatement("select * from ("
						+ makeSqlSelectorForUser(uid)
						+ ") as Temp where frequency = ? "
						+ "and startTime <= ? " + "and lastDay >= ? "
						+ "and freqHelper = ? ");
		statement.setInt(1, Frequency.WEEKLY);
		statement.setLong(2, day + DateUtil.DAY_LENGTH);
		statement.setLong(3, day);
		statement.setInt(4, Appointment
				.computeFreqHelper(Frequency.WEEKLY, day));
		ResultSet resultSet = statement.executeQuery();
		while (resultSet.next())
		{
			aAppt.add(Appointment.createOneFromResultSet(resultSet));
		}
		return aAppt;
	}