/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 6957

only attempt to update date-like nodedata values.

                 String nodedata = null;
                 int count = 0;
     			// select the nodes that are not null
     			// select the nodes that are not null and look like dates
     	        sqlStatement = conn .createStatement();
     	        rset = sqlStatement.executeQuery(
     	            "SELECT DISTINCT NODEID, NODEDATA "
     	            + "FROM " + tableName + " WHERE "
     	            + "nodedata IS NOT NULL "
     	            + "FROM " + tableName
     	            + " WHERE nodedata IS NOT NULL "
     	            + " AND nodedata LIKE '____-__-__%' "
     	            );
     	        count = 0;

Also available in: Unified diff