anchor.diff:          // actually log in and perform statements
           try {
   	  
  -            mCon = DriverManager.getConnection(mUrl, mUser, mPass);
  +             mCon = DriverManager.getConnection(mUrl, mUser, mPass);
   
  -            stmnt = mCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  -             	
  -             ResultSet rset = stmnt.executeQuery(queryAudio);
  +	     //stmntView = mCon.createStatement();
  +             //stmntView.executeQuery(createView);
  +	     //stmntView.close();
  +
  +             stmnt = mCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); 
  +	
  +             ResultSet rsetA = stmnt.executeQuery(queryAudio);
  +             ResultSet rsetI = stmnt.executeQuery(queryImage);
  +             ResultSet rsetS = stmnt.executeQuery(queryScalar);
   	
   	     
  -		
  +		/*
   	     ResultSetMetaData rsetMetaData = rset.getMetaData();
   	     int cCount = rsetMetaData.getColumnCount();
   	     String value;
  
positive.code:   <body>
      <%
          Boolean debug = Boolean.TRUE;
  	//CURRENTLY BROKEN. RELIES ON A VIEW THAT DOESN"T EXIST, THAT I CAN'T MAKE UNTIL I HAVE PERSON.ID
      	/*search conditions. default is blank.*/
          String keywords = request.getParameter("key");
          String sensorType = request.getParameter("stype");
          String location = request.getParameter("local");
  	String dateBefore = request.getParameter("dateUntil");
  	String dateAfter= request.getParameter("dateSince");
  	/*When adding a thing, make sure to add rest of query before hand.*/ 
  	String queryAudio = "SELECT Distinct a.recording_id, a.sensor_id, a.date_created, a.length, a.description FROM sensors sen, audio_recordings a, subscribed_sensors WHERE a.sensor_id in (select * from subscribed_sensors)";
  
  
  	if (sensorType != null && !sensorType.isEmpty()) {
  	   //sensorType = "AND sen.sensor_id = a.sensor_id AND sen.sensor_type = "+ sensorType;
  	   queryAudio = queryAudio + "AND sen.sensor_id = a.sensor_id AND sen.sensor_type = "+ sensorType;
  
  	}
  	if (location != null && !location.isEmpty()) {
  	   //location = "AND sen.sensor_id = a.sensor_id AND sen.location= "+ location;
  	   queryAudio = queryAudio + "AND sen.sensor_id = a.sensor_id AND sen.location= "+ location;
  
  	}    
  	if (keywords != null && !keywords.isEmpty()) {
  	    //keywords = "AND a.description LIKE '%"+keywords+"%'";
   	   queryAudio = queryAudio + "AND a.description LIKE '%"+keywords+"%'";
  	}
  	if (dateBefore != null && !dateBefore.isEmpty()) {
  		//dateBefore = "AND a.date_created <= TO_DATE("+dateBefore+",'mm/dd/yyyy')";
  	   queryAudio = queryAudio + "AND a.date_created <= TO_DATE("+dateBefore+",'mm/dd/yyyy')";
  
  	} 
  	if (dateAfter != null && !dateAfter.isEmpty()) {
  		//dateAfter = "AND a.date_created >= TO_DATE("+dateAfter+",'mm/dd/yyyy')";
  	   queryAudio = queryAudio + "AND a.date_created >= TO_DATE("+dateAfter+",'mm/dd/yyyy')";
  	} 
  		
  	//Currently have redudent search conditions if multiple search conditions.
  
negative.code: 			out.print(value);
  		}
  	}	 
  	*/
  	    /*while going through the result set, must search the descriptions for keywords.*/
              /*Display all hits. */
          stmnt.close();
  