Project

General

Profile

« Previous | Next » 

Revision 2698

Added by sgarg about 19 years ago

Removed sql syntax not acceptable by Oracle.

View differences:

src/edu/ucsb/nceas/metacat/DBUtil.java
356 356 
            "UNION " +
357 357 
                "SELECT docid, rev " +
358 358 
                "FROM xml_revisions " +
359 
                "WHERE docid LIKE ? " +
360 
            ") AS subQueryResult" +
361 
            " GROUP BY docid"
359 
                "WHERE docid LIKE ?" +
360 
            ") GROUP BY docid"
362 361 
            );
363 362 

  		




  364
  363
  
    
      pstmt.setString(1,scope + sep + "%");


  		












Also available in:  Unified diff