Redirect when no records found

Huff,
I am looking for the same exact answer. I used a Before SQL event to filter records according to a user $_SESSION["UserID"] and sometimes users come up short (aka "blank page"). I tried adding some IF statement logic to at least print out a message on screen such as "No records found" but because the page is blank it can't check againt any values or fields to determine if the IF statement is true or false.
Anyhow, if you find the answer please post it here - I'll do the same.
Best,

The idea here is to execute query manually. If query doesn't return any records you can either redirect user to another page (Huff) or display a message on the page (FunkDaddy).