HLRI

Help and Tips


This Help is displayed in a new browser window. Your original search window is still open (if you don't see it, it may be behind this window). When done, close this window by clicking the Close button. If you want to return to the search application, please click on the original window.



Table of Contents

General Searches
Full Text Searches
Accented Searches
Entering Accents into the Database or search boxes
Date of Publication Searches
ISBN Searches
Troubleshooting


General Searches

All searches are case insensitive - i.e. the case of the characters is not important; upper and/or lower case characters can be entered.

Searches are "starts with" or exact match searches unless otherwise indicated. If the field has a * beside it, then it is a full-text field and is searched differently (see below). If you want to search for a string contained within the field, precede the string with "%".

Examples:
Searching for ISBN 010203 will match 010203, 010203456 and 0-10-20399-9. (default is "starts with")
Searching for ISBN %21 will match 0-8032-1296-8 and 7913-21-1

Top of Page

Full Text Searches

The following fields are full text searchable:

This means that you can search for a word within the field (i.e. it does not have to match the whole field).

Examples:
Searching for world in the Title field will match titles that contain the word "world" anywhere in that field such as "A World Apart" and "Tell the World"
Searching for wor* in the Title field will match titles that contain words that start with "wor" (e.g. work, world, wordt, words, etc.)
There isn't an "ends with" search.
*** DO NOT enter the double quotes around the search string - the application automatically adds them.

Remember that some words are considered "ignored words" and will produce an error (e.g. and, between, the, etc.) Here is a list of all English ignored words.

Top of Page

Accented Searches

You can enter an accented or unaccented search string for the following fields: family name, first name, title, publisher, place of publication and pre/postface author.
Both accented and unaccented characters forms of the string will be found.
Example:
Searching for Montral will find the same results as searching for Montreal.
Top of Page

Entering Accents into the Database or search boxes

To enter accents, you can follow the instructions in the document at http://www.virginia.edu/french/resource/students/accents.htm

Top of Page

Date of Publication Searches

For searching, enter the years as four digits yyyy (e.g. 1954). The earliest publication date of a book is 1933. The search works as below:

Top of Page

ISBN Searches

This may apply to BN and LC searches as well. Currently the BN fields are empty and only a few LC fields have data. The application may need to be customized for these depending on the format of these fields.

The recommended way to enter the ISBN in a search is to enter only the 10 digit number without any spaces or hyphens and without the leading "ISBN" (e.g. 0140261907). However, the application will also accept the ISBN entered using one of the following:

This type of search also allows a "starts with" search. If you only know the first 9 digits of the ISBN, enter them in. This may return multiple results. Select the one you want.

Top of Page

Troubleshooting

Sometimes you may get an error message displayed instead of the results or you may not get the results you were expecting. Here are some details that may help:

Problem/Error What it means What to do
Instead of the search form, you see an error message such as "Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied".

Database is down or unable to connect to the database. Print or copy down the error message and contact Support. Try again later.
Instead of the search form, you see a box with a message such as "Application is down until tomorrow". The search application is not available. This usually means it is down for maintenance. Please try again later.
Instead of a list of results, there is a box with the message "There are no results to return to". You clicked the "Last Result" button but you did not do a search first so there are no results to return to. Or if you had to restart the application or browser, the previous results were lost. Start a new search. Fill in the fields on the search form and click the Search button.
Instead of a list of results, there is a message such as "ERROR: Could not get count of: ...

-2147217900: Execution of a full-text operation failed. A clause of the query contained only ignored words.

There are no results for your query. Please start a new search"

You entered an "ignored" word into a full text search box. Ignored words are common words such as 'and' that are not searched for (i.e. ignored) in this type of search. Here is a list of all English ignored words. If an ignored word is entered in the box as part of a string, it is ignored and only words not in the ignored list are searched for (e.g. 'and life' will find entries with the word 'life'). Enter a more specific or detailed string into the full text search box.
Instead of a list of results, there is a box with the message "There are no results for your query. Please start a new search". The search did not find any books that satisfy the criteria you specified on the form. Verify your criteria or try different criteria and search again.
I clicked the Help or Definitions button. How do I get back to the search application? The browser window with the Search application is still open but may be hidden behind one of these windows. (i.e. you have two browser windows open - one with the search, the other with the Help or Definitions.) Close the Help or Definitions window. Or find the browser window that contains the Search and make it the active window (how to do this depends on your computer's operating system). This way you can switch between the Search window and Help or Definitions window.
You get a very long list of books and at the bottom you see a message such as "Found 3491 matches for your query. There are a total of 3491 books in the database".

(i.e. found the same number of retults as there are books in the database). The number of matches may vary depending on how many books are in the database.

Perhaps you left all the form boxes blank or default in which case the search retrieved all the books in the database. Or the criteria specified was too general and you got all the books. Enter more specific criteria and try again.
Instead of a list of results there is an error message that contains a negative number at the beginning of the message. There was a problem retrieving data from the database. Print or copy down the error message and contact Support. Try again with different search criteria.
After clicking Search, you get the error message

"The FROM year is not a valid year (yyyy)" or "The TO year is not a valid year (yyyy)".

You entered an invalid character for the From: or To: date of publication, such as the question mark in "194?". Enter only a four digit value without special characters, such as 1954.
I specified an ISBN (or LC or BN) number and other criteria, but the results don't seem to match the criteria I gave. If you enter an ISBN, LC or BN, all other criteria you provide is ignored. The search is done only on the ISBN, LC or BN value given. If you click one of ISBN, LC or BN but don't enter a value for it, then you will get all books. Please try again.

Top of Page


This Help is displayed in a new browser window. Your original search window is still open (if you don't see it, it may be behind this window). When done, close this window by clicking the Close button. If you want to return to the search application, please click on the original window.