Procedure to switch online textbook search on bookstore website to active or open terms

 Problem Description : 

When Connie in the bookstore requests to change the term drop-down box for the online textbook search to active or open terms the following procedure will apply...

 Resolution : 

************************* THIS IS NOT USED ANYMORE **********************

Bookstore now uses Nebraska books software/website

1. On Osprey in the inetpub>>wwwroot directory locate the file textbook_search.asp in the bookstore folder.

2. Open the file in an HTML editor of your choosing and in code view scroll down to line 59 where the commented text describes the two SQL statements used for the population of the term drop-down box. These SQL statements pull data from the SQL Server database (WinPrism) on Tweety.

3. Whether Connie requires just the active term in WinPrism to be displayed on the web or all open terms, un-comment the appropriate SQL statement and comment out the current statement and Save the file.

She will request only the active term to be displayed on the web when she begins working on an upcoming term and does not wish the open (unfinished) term to be displayed on the web. Once the upcoming term's information is finished she will then want to open that term to the public, thus requiring CSD to change the SQL again. 

 Revision Date : 1/18/2012