« January 2007 | Main | May 2007 »

March 26, 2007

SQL error

There is a known issue which causes an SQL error to occur. If the UPC character string is more than 14 digits this error occurs. Most UPC codes are entered either as 10, 11 or 12 numeric digits. Sometimes there is additional information which causes the UPC field to run longer than 14 characters, such as the additional information (set) or vol. 1. The SQL error will go away if you delete all info after the numeric UPC in the UPC field, Authority field and Key field. The issue has been forwarded to OCLC PICA development to fix.

March 13, 2007

Request title search problems

There is an issue with request title searching. This only affects requests placed prior to the upgrade. Requests placed since the upgrade should not be affected by the title searching problem.

You may want to try searching by author or ISBN instead of title if you can’t find something. Use the Request Advanced Search option. Select the Borrower or Lender radio button to help limit your search. You may need to further limit by checking the Display Not Supplied requests box or selecting the Authorization Status of Complete. Choose the option of Author or ISBN from the drop-down menu options and enter your search term. If you choose to search by author you may want to try truncation like with title searching, for example %grisham.

Don’t hesitate to ask if you have any questions.