Temporary Search Result Tables

These tables contain the results of searches that borrowers make for library materials in the FmLib SQL Server database. The individual tables have names like srch11189825610PM8. About Temporary Search Result Tables describes how these tables are named. The temporary tables are used to redisplay the results of previous library searches.

The temporary search result table diagram shows the column properties of the table.

• The icon column contains the name and location of the icon that appears next to the title on the CML Library Search Web page. For example ../images/iconBook.gif is the icon for the book media type. The name of the icon file is IconBook.gif in the Images directory.
• The link column contains the link to detail information about the title. For example javascript:Dolong(52) passes a bib# of 52 to the DoLong JavaScript function. The DoLong function is found in the CML application client-side script.
• The title column contains the title of the library item. This column is from the title table.
• The coll column contains the media type of the library title. This column is from the title table.
• The call column contains the call number of the library title. This column is from the title table.
• The pubdate column contains the publish date of the library title. This column is from the title table.