Mysql query should force the report to fail or throw an error!!!!

[VENKATA KORR]

I'm a BO developer and I'm trying to create a sql statement in Mysql which should return error when there is no data in yesterday's file.
Below is the query. This query returns null when I added the case statement above the main query and my report runs nothing which should force to fail. I digged many forums and found that 1/0 gives NULL in Mysql and so ended with dead-ends. Could any one plz help me out with this issue.

select
case
when count(*) = 0
then (1/0)
else 1
end
from
(select ...

... where current_date, interval 1 day)
)



Edited 2 time(s). Last edit at 02/28/2011 04:01PM by VENKATA KORR.