That was me... I had logged into a user account to look into some issues and forgot to log back in as myself before answering the question. Sorry for the confusion.
I tested it by adding an echo() statement to the page to see if the WHERE clause was being added to the recordset correctly. It wasn't, so I debugged why and discovered that it was the issue that I pointed out and corrected with the trigger.
Sorry again for the confusion, but I'm pretty sure my solution will work.