% Driver DriverNeeds = (Driver)Class.forName(MM_NeedsOffers_DRIVER).newInstance(); Connection ConnNeeds = DriverManager.getConnection(MM_NeedsOffers_STRING,MM_NeedsOffers_USERNAME,MM_NeedsOffers_PASSWORD); PreparedStatement StatementNeeds = ConnNeeds.prepareStatement("SELECT SUDOC_DEPT, SUDOC_PART1, SUDOC_PART2, SUDOC_PART3, TITLE, NEED, SUDOC_PART2A, SUDOC_PART3A FROM SUDOC WHERE OFFER = 1 ORDER BY SUDOC_DEPT ASC, SUDOC_PART1 ASC, SUDOC_PART2A ASC, SUDOC_PART2 ASC, SUDOC_PART3A ASC, SUDOC_PART3 ASC"); ResultSet Needs = StatementNeeds.executeQuery(); boolean Needs_isEmpty = !Needs.next(); boolean Needs_hasData = !Needs_isEmpty; Object Needs_data; int Needs_numRows = 0; %> <% Driver Driverlastupdate = (Driver)Class.forName(MM_NeedsOffers_DRIVER).newInstance(); Connection Connlastupdate = DriverManager.getConnection(MM_NeedsOffers_STRING,MM_NeedsOffers_USERNAME,MM_NeedsOffers_PASSWORD); PreparedStatement Statementlastupdate = Connlastupdate.prepareStatement("SELECT MAX(DATE_UPDATED) AS LAST_UPDATE FROM SUDOC"); ResultSet lastupdate = Statementlastupdate.executeQuery(); boolean lastupdate_isEmpty = !lastupdate.next(); boolean lastupdate_hasData = !lastupdate_isEmpty; Object lastupdate_data; int lastupdate_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; Needs_numRows += Repeat1__numRows; %>
| Skip to main content. | |||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| Chester Fritz Library University of North Dakota 3051 University Ave Stop 9000 Grand Forks ND 58202-9000 Phone: (701) 777-2617 | Fax: (701) 777-3319 | Contact Library http://www.library.und.edu |
|||||||||||||||||||||||||||||||||