I gather from this that a) there are biblios in the catalogue without a framework b) this causes the report without the null statement to fail. Interesting. Elaine VWML <https://vwml.org> On Tue, Oct 5, 2021 at 9:08 PM Charles Kelley <cmkelleymls@gmail.com> wrote:

Hi again, all!

I found a workaround for my library's problem with the empty downloads of bib. records compiled by

SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS

...

'Author', biblio.title AS 'Title' FROM biblio WHERE biblio.frameworkcode = <<Which framework?|biblio_framework>> ORDER BY biblio.biblionumber ASC

In a duplicate of the report above, I changed the WHERE clause to

WHERE biblio.frameworkcode = '' OR biblio.frameworkcode IS NULL

...

The new report becomes

SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS

...

'Author', biblio.title AS 'Title' FROM biblio WHERE WHERE biblio.frameworkcode = '' OR biblio.frameworkcode IS NULL ORDER BY biblio.biblionumber ASC

While it is not ideal, it works well enough for my library's purposes (counts, identification of bib. records, etc.).

We still welcome suggestions on how to exterminate this bug if you have any. But for the time being, the interim solution above will do.

-

-- Charles.

Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338

Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN

+1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell]

mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p]

linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.