Jump to content

Advanced Find with Publisher?

Fred Slota

Recommended Posts

The new database has apparently had some redesign of some of the Tables.  Not sure there are individual Titles and Issues tables anymore. I have no knowledge of the actual Tables/Columns and structures than any other user of CB.

I can just see little glimpses from the failed SQL statements that are printed in the error messages.

However, with SQL there are two ways to qualify column names (normally to distinguish between the same column name in more than one table).

One is if the Table is given a reference name. An example is FROM TITLES T where columns in TITLES can be reference with T. i.e. T.Publisher.

Two is the actual Table name. An example is FROM TITLES where columns in Titles can be referenced with TITLES. i.e. TITLES.PUBLISHER.

I have worked with Databases and SQL for almost 30 years so I can sort of figure some of this stuff out.  It is not easy to pass that on when so much is just guess work on a tiny view into the database.

Link to comment
Share on other sites

Yes, any column requires data to be useful.

Some of this is the Publishers fault as far as Books go. In the past most all books had a Published date in them. However, for the last several years, this information has been removed. Without this information, there is no Cover date data to add to the Issue.  For current items, Street Date can be used (but, again, only if that information is known and entered).

Getting Street Date for old issues is problematic.

To get around this, to some extent, I use one of my Custom Date columns to store dates (I call it Pub Date) for items that don't have data (actually, I store it for all the items I own). This allows me to do some of the date searches you are probably trying to do.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...