<% 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; %> Federal Depository Library Program
University of North Dakota Home
Chester Fritz Library
'
A to Z Index'Directory'Map
Chester Fritz Library
 
 
 
'
Federal Depository Library Program > UND Offer List
 
Last updated <%=(((lastupdate_data = lastupdate.getObject("LAST_UPDATE"))==null || lastupdate.wasNull())?"":lastupdate_data)%>

The following are available to other depository libraries for the cost of shipping. To request any item, contact:
Kalan Knudson| Phone: 701-777-3316 | Email: kalanknudson@mail.und.nodak.edu

A UND Needs List is also available.

<% if (!Needs_isEmpty ) { %> <% int RecordCounter = 0; %> <% while ((Needs_hasData)&&(Repeat1__numRows-- != 0)) { %> > <% Repeat1__index++; Needs_hasData = Needs.next(); } %>
<%=(((Needs_data = Needs.getObject("SUDOC_DEPT"))==null || Needs.wasNull())?"":Needs_data)%><%=(((Needs_data = Needs.getObject("SUDOC_PART1"))==null || Needs.wasNull())?"":Needs_data)%>. <%=(((Needs_data = Needs.getObject("SUDOC_PART2A"))==null || Needs.wasNull())?"":Needs_data)%><%=(((Needs_data = Needs.getObject("SUDOC_PART2"))==null || Needs.wasNull())?"":Needs_data)%>: <%=(((Needs_data = Needs.getObject("SUDOC_PART3A"))==null || Needs.wasNull())?"":Needs_data)%><%=(((Needs_data = Needs.getObject("SUDOC_PART3"))==null || Needs.wasNull())?"":Needs_data)%>
<%=(((Needs_data = Needs.getObject("TITLE"))==null || Needs.wasNull())?"":Needs_data)%>
<% } /* end !Needs_isEmpty */ %>

 

<% if (Needs_isEmpty ) { %>

There are no items on the Offers List at this time. Thank you, and please check the list again.

<% } /* end Needs_isEmpty */ %>
 
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
AAA Bobby Approved
<% Needs.close(); ConnNeeds.close(); %> <% lastupdate.close(); Connlastupdate.close(); %>