Two more queries

I am teaching a Dreamweaver workshop this evening so I have to head out soon but wanted to post links to two more database queries that I’ve developed.

Author/Resource
: Lists the authors and resources
Resource/Author: Lists the resources and authors

I struggled with the author query (even though I had already successfully created the resource query) because I was matching the ids of the author and resource so I wasn’t getting the right author/resource combination.

I’m also doing some behind-the-scenes troubleshooting to make sure that edits and deletes are not just being made in the main tables but also in the lookup tables. Last night, I discovered that, while the keyword edit/delete was working, the author was not so the links were still in the lookup table. I believe everything is working now but it’s just a reminder that even though things appear to working on the surface, the integrity of the database has to be maintained.

Bookmark the permalink.

Comments are closed.