private static List<Appointment> findOnceByDaySpan(long uid, long startDay,
			long endDay) throws SQLException {
		List<Appointment> aAppt = new ArrayList<Appointment>();

		// select * from Appointment where frequency = $ONCE
		// and startTime >= $startDay and endTime <=
		// $(endDay+DateUtil.DAY_LENGTH)
		PreparedStatement statement =
				connect.prepareStatement("select * from ("
						+ Appointment.makeSqlSelectorForUser(uid)
						+ ") as Temp where frequency = ? "
						+ "and startTime >= ? and endTime <= ?");
		statement.setInt(1, Frequency.ONCE);
		statement.setLong(2, startDay);
		statement.setLong(3, endDay + DateUtil.DAY_LENGTH);
		ResultSet resultSet = statement.executeQuery();
		while (resultSet.next())
		{
			aAppt.add(Appointment.createOneFromResultSet(resultSet));
		}
		return aAppt;
	}