public Recording find(String id, int type){
		try {
			Recording recording = new Recording();
		    Statement st = conn.createStatement();
	        String query = "SELECT * FROM recordings WHERE id = '" + id + "' AND filetype = '" + type + "'";
		    ResultSet res = st.executeQuery(query);
		    if(res.next()){
		    	// return the found record as a whole
		    	recording.setTitle(res.getString("title"));
		    	recording.setDownloadURL(res.getString("downloadurl"));
		    	if(res.getBoolean("complete")) recording.setComplete();
		    	recording.setDescription(res.getString("description"));
		    	recording.setFilename(res.getString("filename"));
		    	recording.setFirstTried(new Date(res.getDate("firsttry").getTime()));
		    } else {
		        recording = new Recording();
		    }
		    res.close();
		    st.close();
		    res = null;
		    st = null;

		    return recording;   
		} catch (SQLException sqlex){
			LOG.error("Java exception " + sqlex.getMessage() + " was thrown with with SQL message " + sqlex.getSQLState());
			return null;
		}
	}